Acc 2000 Like Operator Problem

[MindBender77]

Hello All,
I've always had problems with the "like" operator in a query especially using the wildcard "*". This is my latest issue. I have a query that produces 4 fields if the Line Tech field is like that entered in a textbox on a form. This is what I have so far.

SELECT tbl_security.[Full Name], tbl_PunchCard_Main.[LogIn Date], tbl_PunchCard_Main.[LogIn Time], tbl_PunchCard_Main.[LogOut Date], tbl_PunchCard_Main.[LogOut Time]
FROM tbl_PunchCard_Main INNER JOIN tbl_security ON tbl_PunchCard_Main.[Line Tech] = tbl_security.[User Name]
WHERE (((tbl_PunchCard_Main.[Line Tech]) Like "*[Forms]![frm_Search]![txt_tech]*"));
 

I know (((tbl_PunchCard_Main.[Line Tech]) Like "*[Forms]![frm_Search]![txt_tech]*")) is the problem but, I can't find the correct syntax.

Thanks in Advance,
Bender

[MindBender77]

Problem Solved:

SELECT tbl_security.[Full Name], tbl_PunchCard_Main.[LogIn Date], tbl_PunchCard_Main.[LogIn Time], tbl_PunchCard_Main.[LogOut Date], tbl_PunchCard_Main.[LogOut Time]
FROM tbl_PunchCard_Main INNER JOIN tbl_security ON tbl_PunchCard_Main.[Line Tech] = tbl_security.[User Name]
WHERE (((tbl_PunchCard_Main.[Line Tech]) Like "*" & [Forms]![frm_Search]![txt_tech] & "*"));
 

Bender