Jump to content

[SOLVED] Filter with comma seperated values


surfsup

Recommended Posts

OK this is a bit basic probably BUT

 

I have 2 recordsetsRS1 RS2

 

RS1 has one record  with column Food1 conataing cheese,ham,toast

 

RS2 also has column Food2 but with only one food type. I want to filter RS2 so it only shows those records have one of the comma seperate values in it's Food Column

 

Does that make sense

 

Thanks

 

 

OK this is a bit basic probably BUT

 

I have 2 recordsetsRS1 RS2

 

RS1 has one record  with column Food1 conataing cheese,ham,toast

 

RS2 also has column Food2 but with only one food type. I want to filter RS2 so it only shows those records have one of the comma seperate values in it's Food Column

 

Does that make sense

 

Thanks

 

 

 

Let me try to clarify:

You want to display rows that have no commas in column Food2?

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.