Counting multiple items with name variants 1

[KayJen]

I have the following query attached to a form which works fine. Like "*" & [Forms]![QBF_Items]![WhatItems] & "*"
However, I would like to have another query which will count the items found by this query. Here is where the problem lies. The above query will find all items; i.e., shotgun even if it is listed as shotgun, Remington Shotgun, and so on, but I can't figure out to make it count all shotguns, currently it says I have 1 shotgun and 1 remington shotgun instead of two shotguns. Can this be done, if so please help. Sonny

 

[LarryDeLaruelle]

KayJen:

With the query in design view, click on the View item from the menu bar and click on Total; this will add a Total line directly below the Table Line in the query grid.

Add a field to the query (record id is usually a good choice) and set the "Group By" on the Total line to "Count".

If I understood your question, this should give you the result you are looking for. Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[KayJen]

This was exactly what I was looking to do, Thanks so much, it seems that its the simple things that baffle us so much.