Hi,
I have written a database for a local community house that run courses for locals. I now need to account for convid19 in that if someone has attended a course I need to be able to identify all the people they came in contact with.
I have attached a database with the 3 main table to give an idea of the current state. This is a sample with all active data removed but has the tables and relationships.
I am looking for 2 reports. A 'long version' that will list everyone who has contact with the effected student (say student 'A') even if they appear multiple times as the courses are run weekly.
Then the 'short version' where duplicates are removed, that is we only need one listing per student even though they have come in contact multiple times.
Thanks for any help
Peter
PS I find date fields notoriously hard to work with so when I add to the Attend table there is a field CCDDMMYYYY which the course ID and the date.
I have written a database for a local community house that run courses for locals. I now need to account for convid19 in that if someone has attended a course I need to be able to identify all the people they came in contact with.
I have attached a database with the 3 main table to give an idea of the current state. This is a sample with all active data removed but has the tables and relationships.
I am looking for 2 reports. A 'long version' that will list everyone who has contact with the effected student (say student 'A') even if they appear multiple times as the courses are run weekly.
Then the 'short version' where duplicates are removed, that is we only need one listing per student even though they have come in contact multiple times.
Thanks for any help
Peter
PS I find date fields notoriously hard to work with so when I add to the Attend table there is a field CCDDMMYYYY which the course ID and the date.