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?
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?