check to see if the contents of a field matches field title

M

MeltdownUK

I need to check the contents of a field in an access query to see if the
field contents match the field name. Any ideas
 
R

Rick B

Typically, the field names should not contain data. If your field name is
the same as any of the records, then you are probably working with a flawed
data structure. What are some examples of your fields here? Perhaps we can
help you come up with more of a normalized design.
 
Top