how to get multivalue field in rows in query

[vaibhav2015]

Hi,
I have one multivalued column(Short text), I want to add criteria in query to get selected multivalued field in rows.
example : multivalued field ( 1101, 1901, 4909, 4919) I want to add criteria in query to get value after comma.
1901
4909
4919
I tried InStr function but I am getting Data type mismatch error.
can you please advice how can I add criteria in query to get text after comma?

 

[Minty]

Multi valued fields are not easy to work with - I would suggest having a read here and look at storing the data in a more traditional format http://www.theregister.co.uk/2006/07/18/multivalued_datatypes_access/ , and http://stackoverflow.com/questions/1461582/multivalued-fields-a-good-idea