I also have a query which lists all the surveys but has one extra field where it generates a yes or no, as to whether the survey has been completed.
Okay, my question is how can I create a query so that for each course I can create a list of all the students and whether they have completed the surveys or not?
To do this it would need to do one thing that I don't understand. For a start the query would generate data for just a certain 'course_ID' field. There would then be a number of headings. The first would be the student name. But then the other headings would be all the surveys which relate to that particular course, so it would need to search the 'tbl_surveys' table for all entries that match the 'course_ID' and then make these headings. How could I do this?
I would then want all the entries to bring the 'completed' field from the query, so that at a glance I could look at the table and see the student's name and then whether each of the surveys has been completed or not.
Does this make sense? If anyone has any inkling of what I am asking and feels they might be able to help, please let me know.