urgent: show last date

[99shassan]

Hi, can anyone tell me what to put to show the last date in a query?
I have a field with a few sdates in it, how would I show the latest one?


Thanks

 

[MStef]

Put sort DESCENDING, and
TOP 1 (SELECT TOP 1.........)

 

[99shassan]

TOP 1 (SELECT TOP 1.........)
?

sorry, a little new to ths

 

[neileg]

Although MStef's answer would work, there is a more straight forward one.

Create a select query that shows your data. I presume you have already done that. Now turn this into an aggregate query by clicking the sigma (Σ) button. This will introduce a new row in the query grid. Make sure the date colum is set to Max and the others set to Group By.

 

[MStef]

Look at "DemoTop1A2002.mdb", Query1.