I am trying to create a database that will help me identify if a month is missing based on information that was entered. For example, if I enter in Jan, Feb, Mar, and May for an Employer, can I create a query that "tells" me that April is misssing? I am trying to find the easiest way around this based on the data that is currently in the table. I have the Employer being entered and a month, I just need to know if I am missing a month. The months are entered as 'dates' using January 01, 2010, February 01, 2010, etc..
Thank you in advance for your help!