DMax and more!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a table that saves meter readings and dates. We need to calculate
latest useage ([latest reading] MINUS [second latest]). Dmax function will
return the latest reading, but how can I capture the second latest to use in
the calculation?)
We've been running this thru spreadsheet, but that gets rather
cumbersome!!Thanx - Dave
 
I'd say you need a second query that finds Dmax in the table where [Date
field] < [DMax of table]. If you post the SQL, it would be easier to give you
the syntax...
 
Back
Top