Tallying a listbox's items

[lyrasphere]

I have a listbox that allows multiple entries. If you were to just query the field alone it would return the following:

Apple
Apple, Banana
Apple, Banana, Orange

I need a way to query this field to return something like this:

Apple 3
Banana 2
Orange 1



So that I can place the results in a subreport. Just about everything I have attempted has failed. I either get erroneous results or I get a single count for each entry that I cant tally via a query. Any help with this would be appreciated!

- Russell

[ranman256]

Databases work best counting in a single column (top /down), not left to right. So you must store your results into a column...the above example would be
Apple
Apple,
Banana
Apple,
Banana,
Orange

The query would then count the list.

[lyrasphere]

So how do I get the contents of the listbox which is in the format of:

Apple
Apple, Banana
Apple, Banana, Orange

Into a single column? Thanks!

[lyrasphere]

Scratch that - I see what I was doing. I was building a query off another. For some reason because I had that field in the previous query, it wouldn't allow me to list the contents in a single column that way. I think I have a work around now. Thank you!