Limit the number of records in a query

  • Thread starter Thread starter Shawn
  • Start date Start date
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?
 
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.
 
Back
Top