inti
05-25-2002, 05:55 AM
I have a data with Date Field. And I Want to query the last date but not the last data
|
View Full Version : Last Date but not Last Record inti 05-25-2002, 05:55 AM I have a data with Date Field. And I Want to query the last date but not the last data RV 05-25-2002, 06:47 AM Use the MAX function. RV DBL 05-25-2002, 12:09 PM To get the results you want, you may have to create two queries, one to sort the records by date and then one based on the sort query to pull the Max date for each record. [This message has been edited by DBL (edited 05-25-2002).] |