Hello:
Is is possible to create a report based on two separate queries? I need to create a report that shows total number of registrations as well as the number of registrations generated from fees > a certain number. I can produce a query and a report for each separately, but not combined in one report.

You could use a single query that contains a calculated field. You would add a report break on the calculated field.

Select IIf(YourFee > 999, "B", "A") As BreakField, .....

By adding a header and a footer for this break you can separate the report sections and show subtotals for each group.

Originally posted by rbrule
Hello:
Is is possible to create a report based on two separate queries? I need to create a report that shows total number of registrations as well as the number of registrations generated from fees > a certain number. I can produce a query and a report for each separately, but not combined in one report.

Thank you very much, it worked like a charm.
rbrule