Multiple Criteria

[basilyos]

hello guys

I want to search a table with 3 criterias

this is my code

If DCount("*", "tbl_violation_accepted_telegram", "[Accept_Description_Zone_Number] Like '*" & txt_Accept_Description_Zone_Number & "*' And "[Accept_Description_Zone_Name] Like '*" & txt_Accept_Description_Zone_Name & "*'" And "[Full_Name] Like '*" & txt_FullName & "*'") Then

txt_Accept_Description_Zone_Number Contains Number and sometimes Dash -
Accept_Description_Zone_Name contains alphabet
Full_Name contains alphabet

but access give me error (syntax error)

 

[Minty]

You aren't comparing the result to anything and have a couple of extra " in there. Try

If DCount("*", "tbl_violation_accepted_telegram", "[Accept_Description_Zone_Number] Like '*" & txt_Accept_Description_Zone_Number & "*' And [Accept_Description_Zone_Name] Like '*" & txt_Accept_Description_Zone_Name & "*' And [Full_Name] Like '*" & txt_FullName & "*'") > 0 Then

 

[basilyos]

I changed the code to yours
am getting this error now
the expression you entered as a query parameter produced this error:
'[FullName]'

and big thanks for your help

 

[basilyos]

sorry it's my fault I wrote Full_Name instead of FullName

thank you so much