Date range search multiple date fields

[m17347047711116]

I have made a form that has 5 different date text box's on it, each box represents a different event. The form will completed for 100 people. I want to perform a search of records and preview a report of all the people that will be attending one of the events within the date range.
Thank you in advance for any help

 

[crmarrio]

You will need to use a Union Query to produce a list of all of the dates on one line each.

The MS Access Help files will help you, but you will need to use the same table upto four times in the SQL.

It sounds complicated, but believe me it's not that bad.