Combo Box Value Count

[dlene]

I have a combo box listing several choices for the [status] of a record. I need a summary form showing how many records have "x" status; how many have "y" status; how many "x" or "y" status, along with various other combinations and then the total count of records. These values are derived from an underlying table using the Lookup List.

 

[KenReay]

Hi

You need an agregate query, based on the table

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[dlene]

Good morning:

Thank you for your response.

I'm sorry, but I'm still confused. I identified the information below in the Criteria of my query but it tells me something about a 'string being less than 255 characters.' I then tried the same syntax in a text box on my form and get the Name error. In my query I added my Forfeitures table and then added the Item No and Status fields only to the grid as follows:

intX = DCount("[item no]", "Forfeitures", _ "[status]" = 'destroyed')