Count Function

M

Melissa

I have a report which is printed monthly and lists by
recruit details about contacts or evaluations made that
month.

My problem:

I need the report to then be able to count the number of
times a particular recruit has been contacted since the
previous September 1st and reflect that number to the
right of the recruit's name.

Any ideas?

Thanks in advance!
 
D

Duane Hookom

Create a totals query that counts the number of contacts in the time period
required by recruit. Then add this query to your report's record source and
join the recruit table primary key fields.
 
Top