Gavroche00
Technical User
Hi all,
I have 100+ students that can come at any time during the week and turn in a report. I then enter their mark in my Access DB. However, some of the students don't show at all. I can find out who they are by querying from a master list with 'null' in the report field, but I would like something speedier.
Can I get Access VBA to compare the weekly list with the master list and create records for the 'null' students such that every student would have an entry every week?
If so, what are the first steps one goes through? or can you refer me to other threads, I couldn't find them.
Thanks
David
I have 100+ students that can come at any time during the week and turn in a report. I then enter their mark in my Access DB. However, some of the students don't show at all. I can find out who they are by querying from a master list with 'null' in the report field, but I would like something speedier.
Can I get Access VBA to compare the weekly list with the master list and create records for the 'null' students such that every student would have an entry every week?
If so, what are the first steps one goes through? or can you refer me to other threads, I couldn't find them.
Thanks
David