Unanswered: Creating Query to find Missing Records
Hi all, I am trying to create a query to find records that have not been received. I have a county table that I am matching it against, and a report field. For example, if Dade county hasnt reported for the month of April I want that to be returned in my query. Any ideas on how to do this? I am guessing I would need to do it in SQL but not sure how. Thanks guys..
I'll try, I have a main table that lists all my fields I use on my form, including the county listing from the county table, and a report month from the report month table. The county and report month are seperate tables.
What I am trying to find are counties that have not reported based on the county table and report month. Is it possible to find the county that has not been entered for a report month of april? Meaning that X county is not there for April.
This is what I was looking for. Thanks for your help. This way I cant just enter the report month, event, and event year, and it will show me what county does not meet the criteria ive entered.
WHERE (((COUNTY.COUNTY_NAME) Not In (SELECT COUNTY FROM FORMS WHERE REPORT_MONTH = [ENTER REPORT MONTH] AND EVENT_TYPE = [ENTER EVENT TYPE] AND EVENT_YEAR = [ENTER EVENT YEAR])));