How to make table that is a crosstab

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I write a make table query that produces a crosstab. I know how to
get the result using a crosstab query, however, I want to save the results in
a table in one step. Please advise. Thanks, Bob
 
Try creating a Cross-Tab Query first then a Make-Table Query using the
Cross-Tab Query as the DataSource.
 
Yeah...I thought of this. However, using a Cross-Tab Query as the data source
seems to require that the Cross-Tab Query runs when opening the Make-Table
Query so that the Make-Table Query knows the what fields are available. I was
hoping that there's another way. Thanks, Bob.
 
Sorry. I forgot about this problem with Cross-Tab. Since Cross-Tab view of
data is unmormalised, I never see any need to create a Table with
cross-tabulated data.

One possibility is to exprort to an Excel spreadsheet and import it back,
perhaps.
 
Back
Top