Recent content by Banderberg

No, it is in single form view. The query has parameters that are defined by a dialogue form. This query is also the source for a report. (not sure if this additional info helps)

My form with record source of query has stopped allowing edits. I have reviewed property setting and do not understand what's going on. Any ideas ? Thank You - Bonnie

Access didn't like this and I kept getting error message that the expression was too complex, etc. And I tried everything...here's what finally worked: IFF([ErrorType]="2", 1, 0) Will that cause issue? parans around a number?

The query is the recordsource for the report. Here is the SQL for the query. It may be note worthy that 2 of the fields have criteria that is coming from a dialogue form. SELECT Error_Entry.TM, Error_Entry.Shift, Error_Entry.ErrorDept, Error_Entry.DateError, Error_Entry.DateDiscovery...

CJ can you clarify what the query expression should be. I have tried a few different ones and not getting the results intended. And Yes, the intention is for the report to show the sums but just as a summary in footer, not in the detail (I was making that field not visible on the report).

The name of the text box in the detail is Accuracy_Sum The expression in the footer is =Sum([Accuracy_Sum]) i tried with and without quote ticks around control name. If has a IIF expression not a Dlookup - I'm not sure if that makes a difference, or the terms are synonymous...

Thanks CJ - YES!!! that worked in the reports detail. Now to address the sums in the footer. These are not working and when the report opens a dialogue window appears request a parameter value for these 3 fields.

You are correct - the control source is for ErrorType is: SELECT [Error_Type].[ID], [Error_Type].[Error_Type] FROM Error_Type ORDER BY [Error_Type]; THANKS for all your help!

Attachments....

A million thanks CJ...I feel like I'm heading in the right direction. I followed your instruction above (with novice interpretation) and had less than stellar results: 1) IIf control source in detail. This only worked for 1 of 10 lines. 2) Sum control source in footer. Not working, no totals...

Report has records of errors. There are 3 types of error. In the report footer, I would like a total count (this is working!) and a count by type (can't get this to work). Error Total =Count[ErrorType] Compliance Total =Sum(IIf([ErrorType]="Compliance",1,0)) Audit Total...

I solved - correct DLookUp = =DLookUp("[Name]","TM_Names","[TM]=[TM_Names]![ID]")

I have a report based on a parameter query. One of the parameters is TM Name. This parameter value is selected from a list box. The table on which the query is based also has TM Name as a look-up from a list. So ofcourse the ID is showing in the TM Name field on the report...not the actual...

I've never seen horse meat commercially sold in the US. Nor am I heard anyone eating it knowingly. I would eat, maybe depending on taste, though any red meat is a rarity. What truly amazes me is people are content to eat food packed with chemicals, carcinogens, genetically modified products...

Hello. My name is Bonnie Anderberg. I am relatively new to Access, mostly pulling together a simple database using wizards and online tips for the warehouse where I work in Maryland USA. :rolleyes: During my off time, I enjoy being very active with my 4 children and husband. We are vintage...