Correct dcount syntax for AND criteria?

[Happy YN]

Can anyone please correct my code - I can't seem to get round the & and " and ' parts . Perhaps someone can point me to a good article about all this Thanks

Code:
If (DCount("*", "tblprinter", "[strprinter] = '" & [Forms]![frmbook]![TxtAddPrinter] & "'AND [strcity]= '" & [Forms]![frmbook]![TxtAddCity])) > 0 Then
etc......

 

[FoFa]

The single quotes are not needed, it is a string you are supplying, not a string whithin a string. I would also supply a column name instead of the * in the first reference, but I have never tried the * so I am not sure about that, help says to specify a column or a calculation on the data contained in a column.

 

[Happy YN]

Thanks Pat. Looking at it now I can see everything is nicely paired.Still wouldn't mind an article on single and double quotes and ampersand??

 

[Happy YN]

Thats good Pat -thanks