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

  • Thread starter Thread starter Jado
  • Start date Start date
J

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
 
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
 
Back
Top