Crosstab append query

[J. Shrimp, Jr.]

Is there a way to use a cross tab query to append to a table?
Currently I'm exporting the query to Excel and linking the Excel
spreadsheets back in, then appending the data into an
empty table with the same fields.

 

[Andy]

Are you doing this because your column (field) headings in the spreadsheet
you created Excel are in one single column in your original Access table;
hence, the need for the crosstab query? I am curious, as I had that problem
and thought of using a crosstab query also. My desried column headings were
all in one field in Access. It took me 4 queries to get the Access table I
desired, thanlks to Duane and Steve.

Andy

 

[J. Shrimp, Jr.]

This crosstab query involves several years of monthly data. ranging from 0 -
70 months.
Not all records have 70 months, some have as few as 20, so a cross tab
query
would create null fields where there are no values.
But in any case, I need the data arrayed:
M1, M2, M3, M4, M5, M6......M70.
ID
sub(ID1)
sub(ID2)
sub(ID3)
ID

 

[Duane Hookom]

You can base an append or maketable query on a crosstab query.

 

[J. Shrimp, Jr.]

Of course you CAN base an append or maketable on a crosstab query
BUT you're not going to get the same results as in the crosstab query.
Your columns will be converted to rows, which is not what I need.

 

[Duane Hookom]

Sorry, I'm lost. I don't know what you mean by a crosstab query that
converts columns to rows.

 

[charityrae20]

Question...I'm trying to figure out how to append a crosstab query to update an existing table. My issue is that I need the crosstab query to look at the primary key of the existing table and put the data in the appropriate row/field.