Create table from a crosstab query

  • Thread starter Thread starter Jon Maxim
  • Start date Start date
J

Jon Maxim

I could like to create a link from an Excel table to a crosstab query.
Unfortuntaely Excell will only link to Access tables or select queries. How
can I get the data froma crosstab query into a table?
 
I could like to create a link from an Excel table to a crosstab query.
Unfortuntaely Excell will only link to Access tables or select queries. How
can I get the data froma crosstab query into a table?
Click to expand...

Base an Append query or a MakeTable query on the crosstab query.
 
Does your crosstab have criteria and/or Column Headings?
Could you share the SQL view?
 
Back
Top