Merging 3 queries into one report

[terricritch]

Hi there, I am sure this is possible but I keep getting error messages or blank data showing up.

What I am wanting to do is pull information from the data table based on academic year. I have the queries set up to pick data between certain dates which works fine in the query. When I want to use the queries to produce a report - ie combining 3 years worth of data for a member of staff against their staff code - no data is showing up.

Is anyone able to help at all please. I have set the field properties in the report to select from the right query and based the form on the table (not a query) but it won't bring the data up for me.

Thanks in advance
Terri

[maximus]

perhaps you can upload a sample database. so that I can look into the problem.

[terricritch]

Thanks Maximus for your offer, I have finally managed to clear my head and get it working using a Union Query.