Field Comparison

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

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
 
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?
Click to expand...

Try

LIKE "*" & [Field1] & "*"
 
Back
Top