Help me :(

[radicrains]

How do we add in 3 queries into 1 report.. Basically i have 3 queries that does the same queries but on 3 different fields..



I need to have a report that extracts out these output.. However when i put them in report, the outcome is empty.. I Assume that it's because the parameter I've input on all 3 queries are all together.. So rather than findind a date from 1/5-15/5 in each field, it finds records that contains 1/5-15/5 on ALL 3 fields...


Can anyone please help.. I tried to create sub report, but because of the queries, the outcome is still the same; blank..

[ssanfu]

Not a lot to go on.... you could try:

1) If the three queries have different fields and/or different field order, you could use three subreports.

2) Or, to have the records in one main report, you could use a Union query.

3) If the three queries have the same fields in the same order, put the criteria for the different fields on separate rows.