April15Hater
Accountant
- Local time
- Today, 03:16
- Joined
- Sep 12, 2008
- Messages
- 349
Hey guys-
I'm having some trouble getting a crosstab query to display values from two different table columns in a listbox. I have my first crosstab query that displays ProductionID as a Row Heading, FunctionType as a Column Heading, and TotalPrice as the value. But after it displays the FunctionType Column Headings, I'd like for it to also show those same column headings (labeled slightly differently of course) but with the TotalRevenue field (from the same table) as the Value.
How should I go about doing this? I've tried making two crosstab queries but I couldn't get that to work because the second query is based on the FunctionType as well and it displays the TotalPrice as the value instead of the total revenue. Any help is appreciated.
Thanks,
Joe
I'm having some trouble getting a crosstab query to display values from two different table columns in a listbox. I have my first crosstab query that displays ProductionID as a Row Heading, FunctionType as a Column Heading, and TotalPrice as the value. But after it displays the FunctionType Column Headings, I'd like for it to also show those same column headings (labeled slightly differently of course) but with the TotalRevenue field (from the same table) as the Value.
How should I go about doing this? I've tried making two crosstab queries but I couldn't get that to work because the second query is based on the FunctionType as well and it displays the TotalPrice as the value instead of the total revenue. Any help is appreciated.
Thanks,
Joe
