I have 3 main combos category subcategory and another subcategory. I want to perform a count on these reports so say for example all 3 selections were chosen and the user is presented with their report I want whatever they have chosen to not only give the text details but Count the number that euals their chosen category. I can get this working in a query but I would rather use it on the report thus less queries.

I have been looking at the help files and I have found something which is almost what I am looking for but I cannot get this to work for me. It counts based on a combo selection using DCount. Here is the example from the help

ntX = DCount("[ShippedDate]", "Orders", "[ShipCountry] = '" _
& Forms!Orders![ShipCountry] & "'AND [ShippedDate] > #1-1-95#")

Shippedcountry is the combobox so my combobox would be category and I want to count all the categorys = to the chosen selection in the combo

Any help greatly appreciated!!

[This message has been edited by Hayley Baxter (edited 03-19-2002).]

Ok I have decided to take a less complicated approach to this I have this which is working

=DCount("[Catagory]","Company Details","[Catagory] = 'Selection'")

What is the correct syntax to expand on this ie count occurences for selection then subselection then 3rd subselection??