How do you print 1 item in a group on a report....

[colezpapa3]

I have a report which displays detail data that can contain a value of "CLOSED" or "IMAGE". The report is sorted where all the closed item display followed by the imaged items. They want the report to display ONLY 1 imaged record, the most recent. How can I do that in a report?

 

[dhookom]

Assuming you have your report grouped by the CLOSED/IMAGE field, add a text box to your detail section:
Name: txtCount
Control Source: =1
Running Sum: Over Group

Then add code to the On Format event module like:

Cancel = (Me.txtCount > 1 AND Me.txtStatus = "IMAGE"

Duane MS Access MVP
Now help me support United Cerebral Palsy