Limit the number of records in a query

[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?

 

[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?

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

 

[shawn]

Worked Great,

Thanks

-----Original Message-----


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


.