query last record and date

[Steelersfan26]

I have a table that contains the fields 'date completed' and 'next due'. I need a query that will pull the last record only if the 'next due' is past the due date.
Thanks

[aytee111]

Last record on the entire table? Last record by ID? Last is latest record added? Most recent date completed? Please describe further.

[Steelersfan26]

they'll be going in order by 'date completed'. Basically I'm tracking an inspection that needs to be done every 30 days. So if they complete it on May 1, the 'next due' field will be June 1. So I need the query to pull the last record only if it is past the 'next due' date. Thereby letting the user know that inspection is overdue.

[aytee111]

Click on the Totals icon in query design, group by your main field, select Max of date completed and next due, and a criteria in next due date if < date().