Crosstab append query

  • Thread starter Thread starter J. Shrimp, Jr.
  • Start date Start date
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.
 
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
 
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
 
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.
 
Sorry, I'm lost. I don't know what you mean by a crosstab query that
converts columns to rows.
 
Back
Top