It has been a while since I have worked in Access and I have never worked in 2007 before now. I have a table that contains dozens of fields. I need to create a summary report on the field "Current Job Title", such as:

Accountant 30
Programmer 12
Admin Asst 8

etc.

I have been able to create this report and using Design View, I have it looking pretty much like it is needed. However, I need to only count those rows where the field "Current Employee" is set to "Y", even though this field is not part of the report.

Can someone please tell me how to add this filter or criteria, preferably without VBA.

Thanks,
Jack

Go into the report's Record Source property and set a filter (aka where clause) in the query.

George,

Thanks for your reply. I will have to check this out when I get some time, but I have gotten swamped with other things all of a sudden.

Jack