Log in

View Full Version : Search query



nedy_03
09-13-2007, 03:15 AM
Hello,

Im am using a query that asks for the employee's name. The syntax is :
WHERE (((Contract_munca.Nume)=[]));
But it recognise it only if i put the name entirely. What should I do for make it recognise any part of the field ? ...

Thx,
Nedy

asingh
09-13-2007, 03:29 AM
Try this:

WHERE (((Contract_munca.Nume) Like "*" & [] & "*" ));

regards,

asingh

nedy_03
09-13-2007, 03:39 AM
thxxxx