Search the google archives of microsoft.public.sqlserver.programming group
with the keyword "pivot" and "crosstab" and you will end up with several
solutions posted for similar questions.
Re: Is a dynamic crosstab form possible? ... If pivot tables and crosstab queries give you what you want and the forms ... Try writing a pivot table or crosstab query... (comp.databases.ms-access)
Re: pivot table ... I apologize for the name of the query (as it started out as a Pivot Table ... then I tried the crosstab)... > the cells that are blank in the "crosstab" new table, I cannot add an amount.... (microsoft.public.access.queries)
Re: Is a dynamic crosstab form possible? ... Now one could open up the query without mods and see ... report will always have controls matched to field names. ... I didn't receive much of a response conserning Pivot tables in Access. ... but a CrossTab will work for me too. ... (comp.databases.ms-access)
Re: Sending a Pivot Table by Mail ... Sending an xls file and then manually making the pivot is not ... There are just too many emails and files I send ... I will try the crosstab again..there are ways to make the ... (comp.databases.ms-access)
Re: Pivot Table ... I don't do pivot tables in Access as I find crosstab queries have as much ... If this solution is for a report,... It's not a crosstab query, it's a Pivot Table. ... (microsoft.public.access.formscoding)
