Querying Multi-Value fields

[music_al]

Hi

I have a table (Property_Match) which has some Multi-Value fields in there. For the purposes of this, lets use the Furnishing_Level field. This has "Unfurnished" , "Part Furnished" and "Fully Furnished" as the 3 options.

I have created a form (frm_Property_Match) in which this control is updated. I have also created a query, into which I have entered in the criteria...

[Forms]![frm_Property_Match]![Furnishing_Level]


I would expect this query to return records but it doesnt, unless I delete the multi-value fields from the query. What am I doing wrong ?

Thanks in advance

Al

 

[Kryst51]

What do you mean by multi-value fields?

 

[boblarson]

What do you mean by multi-value fields?

Kryst51 - those are a new field type in Access 2007 and 2010. They are basically giving the user the ability to store multiple items in a single field (although the data is really stored in a hidden table which Access creates for this task). I have not played with them much and MVP Albert D. Kallal has and I think if a search is done here for multi value and his name, the answer may be found.

 

[Kryst51]

Kryst51 - those are a new field type in Access 2007 and 2010. They are basically giving the user the ability to store multiple items in a single field (although the data is really stored in a hidden table which Access creates for this task). I have not played with them much and MVP Albert D. Kallal has and I think if a search is done here for multi value and his name, the answer may be found.

OK, Did a search for both, and no dice, but I did google it, and read up on it a little bit. on the MS site. Thanks! For anyone else whose interested here is a link.