Office 2007 Access: querying multivalue field

[Guest]

Hi,
I am interested in the multivalued field functionality of Office 2007 Access.
Is it possible to query for
A value of any specific field AND One value of a multi valued field ?
Thanks,
Liora

 

[Allen Browne]

In the Field row in query design, enter:
[MyField].Value
substituting your field name for MyField.
Then add the criteria below that.

Query results will be read-only.

 

[Allen Browne]

Liora, I should have also explained that if you omit the .Value part, the
query results are editable. That's probably closer to what you wanted.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

In the Field row in query design, enter:
[MyField].Value
substituting your field name for MyField.
Then add the criteria below that.

Query results will be read-only.

Hi,
I am interested in the multivalued field functionality of Office 2007
Access.
Is it possible to query for
A value of any specific field AND One value of a multi valued field ?
Thanks,
Liora