help with Multi criteria in dcount (1 Viewer)

[kasmax]

Hi
I am using dcount function in a query. when i use two AND conditions it works fine but when i use 3rd AND it give error sayn character lenght must be uoto 2048

its the dcount im using:
DCount("[Category]","[_RawData_All]","[ID]='" & [ID] & "' and [Category]='DOH FastFood'" and [SubCategory]='Pocket Park'")

so can someone please help me. can dcount take more than 2 conditions?

thanks for help

 

[Addyman]

You have an extra Double Quote (") after 'DOH FastFood' I believe that is not required.

Remove it and try then.

 

[kasmax]

Thanks Addyman
Thats has solved the problem.