Hello! I am brand new to access, and have set up a database with three tables: Employees, Questions, and Answers.
The Employee table contains employee data, including "Student Name" and "Area"
The Questions table contains "Question Date" "Question 1" "Question 2" and "Question 3"
The answers table contains "Student Name" "Answer 1" "Answer 2" and "Answer 3"
I am looking to set up a report where I can enter the "Question Date" and see a listing of "Student Name" that do not have a record for that date.
It would be nice to be able to select specific "Area"s of students, but I could make do without that.
Any assistance would be greatly appreciated!
Chris