Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with count on report

Status
Not open for further replies.

irethedo

Technical User
Feb 8, 2005
429
US
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top