how to find the second largest date or a number from a field in ac

  • Thread starter Thread starter Jazz
  • Start date Start date
hi,
I need to find out the previous date than to the maximum date from a date field
Click to expand...
This should do it:

SELECT TOP 1 *
FROM yourTable
WHERE yourDateField < DMax("yourDateField", "yourTable")


mfG
--> stefan <--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

News Largest data breach revealed - 773m email addresses and 21m passwords published 12
Dcount returning no results!!! 0
Query for previous field value 3
Maximum Value in 2 fields of a record 1
The query cannot be completed. 1
Numeric Field Overflow when appending date - how to convert it to text 1
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
Finding a folder with the largest number. 1

Back
Top