I have a report which displays records within a certain date range (as specified in the query which is placed from a form)
For each record, that falls within the date range of a specific part number (the part number is input into the query), I print a summary with the following:
="Summary for " & "'Date' = " & " " & [Date] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"
along with pass & fail information for that record.
This was working fine but something has changed and instead of reporting one detail record for each the count gets set to "5".
Then in the final summary, I tally the total tests passed and the total tests failed and report these with the following:
="Summary for " & "'Assembly Number' = " & " " & [Assembly Number] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"
also:
=Sum([Pass Quantity])
=Sum([Fail Quantity]) ; both of which are fields in my table & query...
The problem repeats itself and displays a total of "5" for each record in the pass & fail qwuantities and the summary
This is probably something simple that I am overlooking but for the life of me I am having a heck of a time figuring it out.
Any suggestions on how to fix this?
Thanks
irethedo
For each record, that falls within the date range of a specific part number (the part number is input into the query), I print a summary with the following:
="Summary for " & "'Date' = " & " " & [Date] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"
along with pass & fail information for that record.
This was working fine but something has changed and instead of reporting one detail record for each the count gets set to "5".
Then in the final summary, I tally the total tests passed and the total tests failed and report these with the following:
="Summary for " & "'Assembly Number' = " & " " & [Assembly Number] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"
also:
=Sum([Pass Quantity])
=Sum([Fail Quantity]) ; both of which are fields in my table & query...
The problem repeats itself and displays a total of "5" for each record in the pass & fail qwuantities and the summary
This is probably something simple that I am overlooking but for the life of me I am having a heck of a time figuring it out.
Any suggestions on how to fix this?
Thanks
irethedo