My database stores our status reports, several projects, several status reports per project. We do our status reports in the middle of the month (dated MM/15/YY) and at the end of the month which could be MM/28or30or31/01). I have a field called Status Report Date. I want the query to only pull up the most recent report. What criteria do I use to filter the date?

Try formatting it to only show the month and year before you enter your criteria? You can put this 'filtering' field in a query without ever showing it on the report, though it might make a nice header.

HTH,
David R