Training Report based on Null Module data

[mousemat]

I have a table containing among other things, dates where training modules have been completed. There are 26 modules to be completed and 180 users. Not everyone has completed all the modules.

I am hoping to create a report showing what modules people need to complete. Any ideas how this can be best achieved?

 

[RV]

Why don't you use the form as provided in this thread:

http://www.access-programmers.co.uk/forums/showthread.php?p=510728

Otherwise, build a report using a similar approach as for the form.

You really should start thinking Access, instead of Excel.
If you would have set up your applic in a proper way, all you would have needed is one query

RV

 

[mousemat]

Thanks RV.

I am fully aware that if the DB had been set up properly I would only have need one query. However, the DB is an inherited one and not one that I have built.

I am looking to produce a list of people who need to complete each module and not the number of people who need to complete each module.

 

[RV]

You'll have to use VBA to get what you want.
Although you did inherit the DB, I would suggest to rebuild your table structure and use a query.
Rebuilding will be a lot faster and easier then messing 'round with VBA.

Just a thought

RV