Crosstab append query

J

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.
 
A

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

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
 
J

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.
 
D

Duane Hookom

Sorry, I'm lost. I don't know what you mean by a crosstab query that
converts columns to rows.
 
Joined
May 25, 2022
Messages
2
Reaction score
0
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.
 

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

Top