Crosstab query that will make a table?

  • Thread starter Thread starter Holly
  • Start date Start date
H

Holly

I have data that is in this format:

ID Client Date
01 Jon 4/20/2006
02 Kim 4/20/2006
02 Kim 4/22/2006


I want to create a table that shows it in this format:

ID 4/20/2006 4/22/2006
01 1 0
02 1 1


I can get it to look like this with a crosstab query....but how can i create
a new table from it that uses the date values as field names?

Any help would be greatly appreciated!

Thanks,
Holly
 
Hi,



Run the crosstab to see if there is no problem with it. Then, make another
query, bring the crosstab as "table" (you should be able to see it under
the query tab), drag the *,in its field list, into the grid, then, change
the SELECT query type into a MAKE-TABLE query type (through the menu or the
toolbar), give a name to the new table when prompted for it, and finally,
execute that query.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top