Missing Data Report Need Ideas on how to do this

[cgemmill1]

I am new to Access and have little experience with VBA. Each month I receive a flat file of data from 265 teams. I need to make sure each team enters data each month. If a team does not enter data, then it is not in the flat file for the month. How can I create a report to identify missing data.

 

[PaulO]

I would take steps to ensure that each record in each of the 265 expected files has a text field which identifies which team (from 001 to 265) has submitted the data. Plus, and additional text field indicating which Month each record belongs to e.g. 2012_07, 2012_08, etc.

With these two fields in place, a rudimentary Query can be written to find out which team has submitted how many records in one or more specified Month and, which have not.

 

[cgemmill1]

Thank you, this was a simple but effective solution.