Field Comparison

[Guest]

My problem is that I want to run eathier a query or macro
that will let me compare the data from one field to the
data in another and perform a sorta Like "*Field1*" and
return a field which is similar to Field 1. I dont think
can use the Instr() functio. Does anyone no a better
solution?

Cheers,
Justin

 

[John Vinson]

My problem is that I want to run eathier a query or macro
that will let me compare the data from one field to the
data in another and perform a sorta Like "*Field1*" and
return a field which is similar to Field 1. I dont think
can use the Instr() functio. Does anyone no a better
solution?

Try

LIKE "*" & [Field1] & "*"