Exception Query/Reports

[Fozi]

Hi

I've got an activity logging system in which users add their daily activity. As an information check, I would like to generate a report which identifies days where the user has omitted to enter activity for given dates.

Is there an inbuilt function that Access has or can anyone point me in the direction of some code?

All help greatly appreciated.

 

[gemma-the-husky]

it depends exactly how you store the user's logs. If each user HAS to file a single return for their daily use, I would be inclined to pre-populate the table with each user's data, then its easy to test for NULL values.

if you have a sparse table, then you have to use either an unmatched queries, probably against a comparison calendar, or use some code to examine the table etc, and establish the missing dates.

there's no inbuilt function to determine if data is not in a file. How could there be really?

you probably need some way of excluding particluar dates anyway (weekends, bank holidays etc) where there REALLY may be no returns.

 

[Fozi]

Thanks

Thanks Gemma. I'm thinking of heading down the route of establishing a Calendar Table and then some unmatched queries.

Cheers for the advice