Can a table be used to search for strings in a text field in a que

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text field in a table called Flower Description. I would like to
search the Flower Description field for different words. Is it possible to
create a separate table called Colors and use this table in a query to find
colors of interest in the Flower Description field?

I know I can create a query and list the colors of interest in the criteria
field as follows: Like "*red*" Or "*yellow*" Or "*blue*".....etc. However, I
would like to create an expression that references a table to find the colors
of interest. (This way I can just modify the table, instead of openning the
query and type "Or "*<color name>*" " over and over for a large list).
 
Naeranth, let's see if I can help:

You have a table called Flower Description:

FlowerID Description etc....
1 Tulips
2 Roses...

Create a table called Colors:
ColorID ColorDescription
1 White
2 Red ....

Create a table called ColorOfFlowers
FlowerID ColorID
1 1
1 2
2 1...

Link them so:
- a flower can have "N" ColorOfFlowers
- a color can have "N" ColorOfFlowers

A simples query with these 3 tables within the wizard may solve your problem

Take care

Mauricio Silva
 
Back
Top