How to count values of multivalued columns using expression builde

[Gajendra]

Hi I am implementing a report for Access database. In this database we have
some multivalued columns and I want to count on values, I mean

Ex. Column Name: Category
values: Student/Professor/Faculty

I want to count how many students, faculty, professor in the table and
how many students are professor and how many students are faculty or how
many persons lie on all three categories.

I am using expression builder for this I tried
DCount("

![ID]","Table", "

![Category] Like 'c*' ")
it is returing Error###

but
DCount("

![ID]","Table", "

![Name] Like 'c*' ") is working

It means this expression is working only for singlevalued columns, can you
tell me how to do it with multivalued column...
or any other way to solve above problem(count)?

 

[John Spencer]

I don't believe you can use the VBA aggregate functions (Dcount,DSum, etc)
with a multi-value field.

I am willing to be corrected. I would offer an alternate solution except I
avoid using multi-value fields because of such problems as this one.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Gajendra123p]

Can you one tell me how to extract values for multivalued columns,
then I'll figure out something.