How Do I Do - Like "*String*" - in DCount Function..?

[Jado]

How Do I Do - Like "*String*" - in Access 97 DCount Function..?

my example (not working)

Dcount "[Tel No]", "Table1","(([Field1]) = 'myItem') AND (([Field2]) Like
'*Sale*'

Thanks

Jado

 

[John Spencer (MVP)]

Add parentheses around the parameters AND make the criteria a string by adding a
closing parentheses.

Dcount ("[Tel No]",
"Table1",
"([Field1] = 'myItem' AND [Field2] Like '*Sale*'")

That should all be on one line, but I broke it up into three lines for visual
clarity