top 10 selection ... (Not a quickie)

[callhandler]

I have a list of dates ...

The date field has data in the format:
mm/dd/yy hh:mm (ie it has time as well)

I want a query to select the 10 most recent days.

This sounds easy to me ... but I can't break it on one query!

 

[PaulBricker]

Add a new field to your query
MyTopDate:Format([DateField],"mm/dd/yy&quot
then sort this field decending. Then select the Top 10 from the Top dropdown box on the toolbar. It's the one with the word "All" usually showing.

Paul

 

[cmmrfrds]

The default for date arithmetic is days so comparing to the current date -10 should do it.


select DateField from yourtable
where Format([DateField],&quot;mm/dd/yy&quot <= (now() -10)

 

[callhandler]

thanks for the last post, but i do not necessarily have continuous dates, so it's useful, but not the answer....
the earlier response solves the problem!

 

[cmmrfrds]

Okay, the top 10 works well for the 10 most recent records not necessarily the 10 most recent days depending on if there are multiple records on a given day.

 

[r937]

>> Add a new field to your query
>> MyTopDate:Format([DateField],&quot;mm/dd/yy&quot
>> then sort this field decending.

surely you meant to say yy/mm/dd

otherwise you'll have nothing but grief in january