How to insert the result of a cross tab query in to table

[Buj123]

Could any one help,
How to insert the result of a Cross tab query to a table.
What Sql statement will do that?
Please help

 

[mgolla]

Try something like this:

INSERT INTO TableName( FieldName, FieldName1)
SELECT CrossTabQuery.FieldName, CrossTabQuery.FieldName1
FROM CrossTabQuery;

HTH
Mike

 

[luceze]

If you already have the crosstab query made, go into design view, Select "Make Table" from the query type drop down, enter the name of the table and run the query. It will create the SQL for you.

HTH,
Eric

 

[Buj123]

Hi mgolla,
i don't know what will be the fileds name exactly, bacuse for one campaign there can be from 1 to any number of coupons, and i am creating this crosstab on the coupon names. SO,it didnot worked.

Hi luceze
I have tried your suggestion, its creating the table but only thing is its not making the table in crosstab form, its creating a bit different.