Binding 'count' <>1 to appropriate key

[Captain Database ...!!]

It is I, Captain Database ...!!



I have a query counting like-results of one field, which is a function of other fields. When I add a key-field, however, it merely counts results as one (there being, quantitatively, one result per every key value). I have thus tried to use one query to list the like-results of different key values, and another to associate their counts (i.e., <>1) with their host-key values. When I try to do so, however, I get an error that I cannot refer to both a table, and a query derived from that table, in the same new query. Doesn't entirely make sense to me, but any suggestions of a work-around?

Captain Database ...!!
"When your data calls out for a hero"

[Rhino373]

This is because when you have a key field, no 2 entries can be the same. This means that when you have a table of lets say 10 items and try to group by that key field you still see 10 items because each entry in the key field is unique and thus its count is also always one.

Group by the "like results of one field" and then also display the count of that same field.

So if you have like

Pie | Apple
Pie | Cherry
Pie | Peach
Drinks | Cola
Drinks | Water

You would get

Pie | 3
Drinks | 2

Basically don't group by the ID when asking for counts

[orange]

Perhaps you could show us your table structure and the query(ies) you have tried.
As well you could show us exactly the error message you received.
Also, if you could describe exactly what you want to achieve using the fields in your table/query, you're more likely to get a meaningful response.