Multiple Crosstab Query

[Badswell]

I am currently working on a project comparing a current item program (cost, price, mfg #, etc) vs a series of proposal against the same program. Using crosstab queries, I have gotten the results to resemble:

Current Program | Proposed Cost 1 | Proposed Cost 2 | Proposed Price 1 | Proposed Price 2 |

Rather than grouping the results by similar fields (All the proposed costs, then all the proposed prices, then all proposed mfg #'s, etc), is there a way to group the results by proposal program (Under proposal #1, listing the cost | price | ..., then proposal #2 next to it and so on)..

Current Program | Proposal Cost 1 | Proposal Price 1 | Proposal Cost 2 | Proposal Price 2 |

Thanks for any help here, kinda stumped.

 

[Pat Hartman]

The Crosstab can only return a single value per column. You'll need two separate crosstabs and a third query to join them.

 

[Badswell]

I have that much figured out. Currently I have 2 crosstab's being grouped together, but the results are grouped by the value of the individual crosstab..
cost for #1, cost for #2, price for #1, price for #2

I'm looking for the query result to be grouped by proposal, showing a set of fields.
cost for #1, price for #1, cost for #2, price for #2

 

[Pat Hartman]

If each crosstab produces correct data, then joining the two queries will produce the recordset you want. Field order is irrelevant but you can control it if you choose by selecting the columns specifically rather than using the * notation.