How can I convert union into a new table in Access?

R

Roman

Is it possible to convert union into a new table in Access?
I need it to see union's data in Excel Pivot table.
Thanks a lot for your help.
 
D

Duane Hookom

You can base a pivot on a union query. If you really want to create a table,
you can create a Make Table query based on your union query.
 
J

Jeff Boyce

I take it, then, that you are exporting your results to Excel to create a
pivot table there.

You can simply "export" the union query itself and do your further
processing in Excel.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To make pdf to work as word 1
Excel does not accept text format! 0
Dealing with a Pivot Table (when I don't want to) 0
Macro to copy table of contents to a new doc 0
Power Pivot. Yikes. 0
How to have two tables on same line? 1
How can the font and size of (all) citation numbers be altered? 1
Duplicates in union query 3

Top