Select multivalued field from access table

[ThePegass]

Hello,

Im not a programmer, noob in sql statements, google helps me every day . But I cant find anything helpful concerning my simple problem I hope. I have a multivalued field in the one field in of access table.
mvf.JPG

My macro code:

Please Login or Register  to view this content.

When there is only one value in the field "Col1" (Order or Operation) I get correct value. But it there are both I get nothing (value is empty).
How to solve it?

Thanks.

[Norie]

I'm afraid you can't use ADO for multi-valued fields, you need to use DAO and OpenDatabase.

Off the top of my head, and untested, here's how the code might look.

Please Login or Register  to view this content.

[ThePegass]

Thank you. I got mismatch error on line:

Please Login or Register  to view this content.

[Norie]

Like I said that code was off the top of my head and untested.

Not at home right now but I'll test it when I get back.

In the meantime I would suggest looking at the Fields collection of the recordset rsRecord in the Locals Window.

[ThePegass]

Solved, in the end I found useful code, modified little bit:

Please Login or Register  to view this content.

[Norie]

Sorry for not posting 'useful' code.