Query Criteria

[cp3]

Hello! I am just starting out learning access and I want to create a query for a dataset with particular criteria. I want to run it monthly and want to select for records where a particular category is missing for that month. For example, if a record didn't have data input for a particular column (but might have data in other columns) in that month, I want to be able pull all the records with this criteria each month when I check on it. Thank you for all your expertise and help!

[CJ_London]

no information provided to provide a focused answer but perhaps something like

SELECT *
FROM myTable
WHERE myField is null

[cp3]

ah yes sorry maybe I didnt explain it well enough. I was wondering if there is a particular code I can write in the criteria box when i create a new query that can select all of the records with a missing value in a particular column for that current month. So it only selects the records with missing for the month during which the query is ran. Is there a way to make it pull this for the current month without needing to manually select the current month?

[Welshgasman]

Yes. Use the month() and year() functions.