Transferring Excel Report to Access (Access 97)

Topic

New Reply

I have to develop a report in Access that was previously developed in Excel. The Excel report source is a pivot table with 3 rows and 5 columns. The pivot table source is an Access Database. How do I develop a query to mimic the pivot table? I tried the crosstab query, and it states there are too many columns. I have attached a sample of the report in excel.
Thanks,
newcomer to Access

Reply | Quote

Replies

IN queries you need to look at the View/Totals option

In Reports you need to look at the sorting and grouping options as well as section headers.

Also, in reports, look into the iif function in conjunction with sum i.e., sum(iif([fieldname])=criteria,1,0))

HTH.

Reply | Quote

There is a Solutions.mdb database for Access 97 that should have been included with the product and contains an example of an advanced report based on a multiple-fact crosstab query, which sounds like what it you want. MSKB article ">Q248674 for a link to the Solutions9.mdb download site.

Reply | Quote