Wildcards in Lookup tables

T

TAH

I'm trying to set up a lookup table as follows:

Category Color
A Red
B Blue
* Green (anything not A or B is green)

The query won't recognize the * as a wildcard for some reason, it returns no
data for anything other than A or B. What am I doing wrong?
 
J

John Vinson

I'm trying to set up a lookup table as follows:

Category Color
A Red
B Blue
* Green (anything not A or B is green)

The query won't recognize the * as a wildcard for some reason, it returns no
data for anything other than A or B. What am I doing wrong?
Click to expand...

Assuming that a "lookup table" recognizes wildcards.

* means "match anything" only in a Query using the LIKE operator. If
you JOIN this table to another table, the * in this table will match a
literal asterisk in the other table, and nothing else.

John W. Vinson[MVP]
 
Top