Report from a Union Query

[Carlton]

The union query I made has all of the information I need in the report. But the report I make from this query doesn't include the information that the union query produces. The union query combines information from 2 tables and divides the number found either by 1 or 2. Is there a way to get the results into a report? Should I export it to Excel and then back again? Thanks for any help.

[ranman256]

Use a report wizard, select the union query, and it will build the report with all your fields.
or
you can export to Excel.

[Carlton]

I tried the report wizard and it doesn't bring in the calculated field. I did export the query to excel and then imported back into Access into a table and then made a report based on that table and that worked but I'm thinking there should be a better way.