Hello:
I am trying to create a Pivot table in an Access 2003 report. I have SQL that retunrs 6 columns of data, (month_year, units, products_per_unit, gross_sales, price_pe_product, and avg_days_to_fulfill). I would like the columns of the pivot to be the months of the year, and a row for each of the other columns, with a total column at the end. It can be done in Excel, but I need it to be in a report. The crosstab query would be great, but it only allows me to choose one row/data summation, and I need 5. I can do some coding, but am by no means an expert. Can anyone help?
Thanks,
cbj