Extrating Marketing Date

[Dazzy]

Hey All

Just cant see the solution to what I believe is an easy question.

I am looking to collate marketing data from different areas of our DB into a Marketing Hub.

• We have to collect various feedback at different times, if a client on a programme completes a course, they give feedback for that course.
• 13 weeks after a client completes the programme we have to get them to complete a destination survey.

On both these forms it asks would they be interested in doing any more courses. This data is then stored in the Courses table and Projects table respectively.

I want to create a query to become the record set for a new form which only shows those students that have stated they would be interested in doing other courses.

Five of the options or Yes/No fields, and one is a text field (which courses, other essentially).

How does one do a query that only shows records where any one of 6 fields is not null?

 SELECT Students.ID, Students.[First Name], Students.[Last Name], Courses.[Sage Accounts], Courses.[Sage Payroll], Courses.[First Aid], Courses.[Food Hygiene], Courses.[CV Services], Courses.[Interview Skills], Courses.[Which Courses]
FROM Students INNER JOIN Courses ON Students.ID = Courses.ID;

This has basically kept me awake all night and for the life of me I cant see the solution to what seems an easy problem.

Thanks

 

[nathansav]

WHERE (field1 =true or field2=true or field3=true)

 

[Dazzy]

Thank you, don't know why I couldn't see this earlier.