Trouble with querry on multi valued field (Reserved error -3087)

[anartey]

Hello,



I have been getting an errror when i querry a multivalued fied. In the querry, I am trying to count the number of entries in the multivalued field. Can you please help ?>

[June7]

My first advice is to not use multi-value fields. I won't.

However, here is one possible approach. Do a query that lists all the values as separate records. Review this http://office.microsoft.com/en-us/ac...49297.aspx#BM4. Then use that query as the source for an aggregate query.

[anartey]

Thanks. How can i get around not using a multi-valued field ? My problem is, I need to have a list of options to choose from and I want to be able to count my list of options

[June7]

Instead of multi-value field would need a related table. The table would have the appearance of the query that 'flattens' the multi-value field. What do you mean by a 'list of options'? You want choices restricted by value in another field? That is dependent (or cascading) comboboxes. Check this tutorial http://datapigtechnologies.com/flash...combobox2.html

[anartey]

Option as in List that you can choose from.

Can you please provide me with an example of what you mean (in access format). Thanks !

[June7]

I think the tutorial link I provided offers an example of restricting user choices based on another value.