Access Crosstab to Table

R

Richard John

Is it possible to directly create a table in MS Access from a Crosstab query? I
know of no way of doing this except via code.

Thanks
 
G

George Nicholson

afaik, you can't do both in one query, you'd have to use two: 1)crosstab and
2) maketable based on Query1
 
J

Jeff Boyce

If you can run a Crosstab Query to get the values that you want, why do you
want to create a new table? It is generally neither necessary nor a good
idea to store calculated values. There are exceptions, but you haven't
described enough about your situation to be able to offer specific
suggestions...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top