Create a table from a crosstab query

Question posted by: Newbie12345 (Newbie) on October 31st, 2007 05:34 PM

I have a crosstab query which gathers data from a regular table and creates columns for the months in the year with volume for each month. I want to be able export/send the data to a brand new table, which would keep the new formating with the months as fields.

So basicall i want to create a table from that crosstab query that looks identical to the query. I tried using a make-table query but this just puts all the data back into the way the original table was, without column fields for the months.

Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).

nico5038

Moderator

2,031 Posts

October 31st, 2007
07:37 PM
#2

Re: Create a table from a crosstab query

Use the save crosstable query as the input for your Make-table query.
(Second tab when defining a new query holds the queries you can use)

Nic;o)

im dj

Newbie

1 Posts

July 25th, 2008
09:12 AM
#3

Re: Create a table from a crosstab query

Quote:

Originally Posted by nico5038

Use the save crosstable query as the input for your Make-table query.
(Second tab when defining a new query holds the queries you can use)

Nic;o)

im a newbie on doing cross-tabs and make-tables...how do I do this?

Thanks!

Not the answer you were looking for? Post your question . . .
182,494 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Top Microsoft Access / VBA Forum Contributors