Can you make a cross tab query into a table?

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

Guest

I want to make my cross tab query fields into fields for a table. How can I
do this with out having to put each one in manually?

Thanks
 
Create a CreateTable query that is based on the cross tab query

SELECT CrossTabQueryName.* INTO TableName
FROM CrossTabQueryName
 
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

Cross Tab Query with two values 1
Cross Tab Query with DataSerial 2
cross tab query outer join 1
Field Does Not Appear in Cross Tab 1
crosstab query with datea parameters 2
Using automation to load a cross tab query to Excel 11
Make table query: [Enter 1] AS Test 1
Sorting in a Cross Tab Query 2

Back
Top