If I have a cross tab query where the columns will be static each tinme it is run, is it possible to append the data to another table? Or is it possible to make a table with the results of my query?
Thanks.
Novice
Windows XP 
Access 2003
If I have a cross tab query where the columns will be static each tinme it is run, is it possible to append the data to another table? Or is it possible to make a table with the results of my query?
Thanks.
VIP
Windows 7 64bit Access 2010 32bit
Why is that necessary?
The CROSSTAB can be the data source for an INSERT or MAKE TABLE sql action.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Add/append data to crosstab query
Posting Permissions
Reply With Quote