Like Criteria

[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

 

[Dale Fye]

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.