Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filtering a Query for lastest 100 Records

Status
Not open for further replies.

homeguard

IS-IT--Management
Jul 12, 2007
47
US
I have a Query that has something like 800 records in it and have it sorted by date, i want to filter it for first 100 records that appear in the query. is there a quick command for this or is it more complex?

I went into the query properties and changed max records to 100 but it didnt seem to do anything?

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top