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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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
 
Back
Top