Query on a field that has several values

[NielsE]

I am using a form where I select values from combo boxes to enter parameters for a select query. It works fine where the table queried only has one value in the field concerned. However, it does not work on the fields that have several values (entered through a multi-selection box).
Are there any ways to query fields with a multi-selection?
Thanks, Niels

 

[neileg]

If you are saying that you have a list of data held in one field in one record, you are forever going to have problems with this. If you have multiple data values, you should store this in multiple records. This may be in a separate table.

 

[NielsE]

Thanks for your comments. However, with the kind of data base I am developing I think it will be most practical if some fields in one of the tables include severaL values (they are seperated by a semicolon and a space).
As mentioned before I use a form to enter the parameters ([Forms]![formname]![fieldname] and it works fine on the fields with only one value. Is there any way at all to have it work on the multi-value fields? that would save me from rearranging the whole data base structure.
Many thanks in advance.
Niels

 

[RV]

However, with the kind of data base I am developing I think it will be most practical if some fields in one of the tables include severaL values

You're wrong, it's not practical, on the contrary
Take the expert advises (which you got on at least two different forums!) and normalize your structure.

RV

 

[neileg]

RV hit the nail on the head. You can always add data together when you need to. Seperating it out is infinitely harder.

I suspect that your approach is fixed around the table containing what you want the user to see. Users don't see tables, they see forms and reports.

 

[NielsE]

Thanks all, you convinced me.
Niels