Show 2nd last reocrd based on this criteria

[Guest]

Appreciate if you can help me figure out a way to resolve this query.
I'm trying to query for customer maintenance records based on the criteria
below but I'm not sure how I can go about doing so:

BEGIN checking from the last record:

IF the "Support Flag Field" = "NO" AND "Start Date field" <= Now() - 60days
THEN shows only the the previous record before the last record
ELSE shows the last record

 

[[MVP] S.Clark]

Getting the last record can be found here:
http://www.mvps.org/access/queries/qry0020.htm

After finding the ID of the last record, then writing the query(probably
another one) to do the rest should be easy.

 

[Guest]

Thanks S.Clark. Now I've gained more knowledge reading through the website.
Appreciate your help.