combine two cross-tab queries in a report

ccg121

New member
Local time
Today, 02:54
Joined
Mar 19, 2013
Messages
3
I understand that I can't set multiple "values" in a crosstab query but I need to have both a UPC and a price display in a report(Price List) for Our Exotic Wood selections like so:

Wood Type 4/4 5/4 8/4 12/4 16/4 20/4 24/4

Afr. Mahogany |||| ||| ||| |||| |||| |||| ||||
$15 $20 $30 $40 $50 $60 $70

Rosewood |||| ||| ||| |||| |||| |||| ||||
$15 $20 $30 $40 $50 $60 $70
I have 2 crosstab queries one that gets the price and one that gets the UPC I can join them and get it to print on every other line but there is no way that i can find to print two lines at a time in a report so my question is there a way to achieve the outcome described above with two crosstab queries? do I need more queries or a different kind of query?
 
You you want to have it show like that, (if yes there is no need for two crosstab query, you can do it in one crosstab query)?
Post you database with some sample data, (zip it if you don't have post 10 post).

attachment.php

v8AhIVWDHiT7aAAAAAASUVORK5CYII=
 

Attachments

  • Wood.jpg
    Wood.jpg
    31 KB · Views: 750

Users who are viewing this thread

Back
Top Bottom