Finding First Previous date in a query

[Hamboneman]

I am working on a Preventive Maintenance Database and want to take the last date of PM and compare it to the previous date of PM. How can I get a query to return the first previous date of PM from a table of completed pm dates?

 

[mikey69]

Try constructing a query with the necessary criteria to gert the right recordset. Then sort the query date descending and set it, in its property table, to return the top value only.