|
View Full Version : urgent: show last date 99shassan 03-26-2007, 04:04 AM 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 03-26-2007, 04:19 AM Put sort DESCENDING, and TOP 1 (SELECT TOP 1.........) 99shassan 03-26-2007, 04:26 AM TOP 1 (SELECT TOP 1.........) ? sorry, a little new to ths neileg 03-26-2007, 04:35 AM 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 03-26-2007, 04:39 AM Look at "DemoTop1A2002.mdb", Query1. |