Unanswered: Creating a table from a crosstab query
How do you create a table as the result of a crosstab query?
The problem that I have is actually more complex. I want to generate a graphic inside a form based on a crosstab query. I want to be able to select a value from a combo box that will determine the graphic that will be displayed. This value will be used as a select criterium in the crosstab query. I know how to do this with a normal query. Unfortunately, it doesn't seem to be possible with a crosstab query (any thoughts???). I think I can solve the problem simply by using a table as the source of the graphic, but to achieve this I need the output of my crosstab query to be stored as a table.
what i do is
1 first create the query the make the Crosstab
2 then create a mk table that read the Crosstab query
then Run 2 which will run 1 and then make the table
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.