Filtering a Query for lastest 100 Records

[homeguard]

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.

 

[Remou]

You are looking for TOP 100, I believe.

 

[homeguard]

ahh very good, thank you sir