10 most recent entries

[taylor]

Hi,

I am trying to set up a query which will filter out the 10 most recent additions by date.

My table contains a 'Title' field and a 'Date Added' field. I am trying to get the 10 most recent titles up in a query so I can then create a report based on this.

So far I have managed to single out the most recent date simply by using the MAX function but am a bit lost from there on..

 

[ThreeCrow]

In your Query Design, on the tool bar you should see (middle) a ComboBox with the word "All" in it. Click on the down arrow. Select 10.

The date Field should be first column of your Query

 

[taylor]

Perfect.

Thanks mate