Query for only the three most recent date entries 2

[GordonV]

I am having great difficulty narrowing a query to locate only the three most recent dates entries for a particular record.<br><br>The database is set up as a main table with a unique record number, then a second table with several date style entries which relate to the first table.&nbsp;&nbsp;<br><br>I have been able to retrieve events for the past thirty days but I really only want to show the three most recent.<br><br>Any thoughts,<br><br>Thanks<br><br>Gordon

 

[elizabeth]

An easy way to do this on a <i>form</i> is to use a listbox or combobox with the underlying query sortying in reverse chronological order. Then set the control's ListRows property to 3. It will display the top three but the user can scroll down for the rest.

 

[harryrich]

First write your select query to sort descending on the date field.&nbsp;&nbsp;Then go to Query Properties. (You can get there using the View/Properies menu or by right clicking on the background of the QBE window where the tables sit.) The third field down from the top is Top Values.&nbsp;&nbsp;It has a drop down list but will allow you to type in 3 to select the first three items.