Querry help.. compare multiple makes & models

[BigBlueScreen]

Hi,

What I'm trying to do is set up a crosstab to compare two makes & multiple models. Here is the querry I am currently using which pulls up by make & model, and allows you to choose various options.


SELECT Manufacturer.Manufacturer, Machines.Machine, Catagories.Catagory, SubCatagories.SubCatagory, Items.Item, PricingDetail.Price, Items.Details, PricingDetail.PricingOption, PricingDetail.MachineID, PricingDetail.Print
FROM (Catagories INNER JOIN SubCatagories ON Catagories.CatagoryID = SubCatagories.CatagoryID) INNER JOIN (Manufacturer INNER JOIN (Machines INNER JOIN (Items INNER JOIN PricingDetail ON Items.ItemID = PricingDetail.ItemID) ON Machines.ID = PricingDetail.MachineID) ON Manufacturer.ID = PricingDetail.ManufacturerID) ON SubCatagories.SubCatagoryID = Items.SubCatagoryID
WHERE (((PricingDetail.MachineID)=[forms]![mainentry]![combo5]) AND ((PricingDetail.Print)=Yes) AND ((PricingDetail.ManufacturerID)=[forms]![mainentry]![combo3]));

2nd Manufacturer = combo29
2nd Machine =combo31

Any help would be GREATLY appreciated..