Access Crosstab to Table

  • Thread starter Thread starter Richard John
  • Start date Start date
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
 
afaik, you can't do both in one query, you'd have to use two: 1)crosstab and
2) maketable based on Query1
 
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
 
You must log in or register to reply here.

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

Create table from a crosstab query 2
Is it possible to get Access to ignore not recognizing a field nameusing some sort of error handling 1
Form based on crosstab query 1
problem with crosstab query 1
Crosstab query 1
Loosing fields when creating a crosstab from a table 1
Crosstab Date Range in Reports 3
dynamic columns number in crosstab report 4

Back
Top