Limit the number of records in a query

S

Shawn

I am making a database for client contacts. I want to
print a report to show times the clients were contacted.
This report is based on a query contacts with the
clients. My problem is that I would like to limit the
number of contact with the specified client to the last
four contacts made. How can I do this?
 
J

John Vinson

I am making a database for client contacts. I want to
print a report to show times the clients were contacted.
This report is based on a query contacts with the
clients. My problem is that I would like to limit the
number of contact with the specified client to the last
four contacts made. How can I do this?
Click to expand...

Sort by the contact date and set the TOP VALUES property of the query
to 4.
 
Top