Like Criteria

  • Thread starter Thread starter Neal C
  • Start date Start date
N

Neal C

I have joined data in a query from one table e.g. [data1]& "" &[data2]. When
I add the criteria 'Like "*" & [Select Data] it does not work properly.
Has anyone tried this?
any ideas?
Thanks
 
Neal,

the criteria, as you have it shown will only identify those records where
the final characters of the two concatenated fields match the characters you
enter in the popup box. I think what you are looking for is:

Critieria: Like "*" & [Select Data] & "*"

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.
 
Back
Top