I'm having an issue with a Crosstab Query/Report.
Query setup. Column Headings is the Month. Row headings is Product Name and Price/Gallon.
Under each Month, I can sum the gallons of product sold, but I also want to calculate sales. I can do that on a report (with other limitations), but not within the query. Can it be done in the query? I'll say until now, I've been fine with just one set of data in each column and I've never attempted more than one piece of data.
I know this is for a separate section on the forum, but what I can do on a report is multiply the Price/Gallon by the Gallons Sold, but the restriction that comes about is that I cannot sum the total sales in a "footer" section. As simple as =sum([JanSales]) just doesn't seem to work, where it would in a normal query report setup.
I use Office 2010 on Windows 7 32bit. Is there a work around/possibility to allow the two pieces of data and also be able to total the gallons and sales under each month without generating two reports?
Thanks,
Ed
Query setup. Column Headings is the Month. Row headings is Product Name and Price/Gallon.
Under each Month, I can sum the gallons of product sold, but I also want to calculate sales. I can do that on a report (with other limitations), but not within the query. Can it be done in the query? I'll say until now, I've been fine with just one set of data in each column and I've never attempted more than one piece of data.
I know this is for a separate section on the forum, but what I can do on a report is multiply the Price/Gallon by the Gallons Sold, but the restriction that comes about is that I cannot sum the total sales in a "footer" section. As simple as =sum([JanSales]) just doesn't seem to work, where it would in a normal query report setup.
I use Office 2010 on Windows 7 32bit. Is there a work around/possibility to allow the two pieces of data and also be able to total the gallons and sales under each month without generating two reports?
Thanks,
Ed
