Access Dcount Syntax

[Jagstrom]

=DCount("[Disposition]","History Query","[Disposition]='Wrong Number'")

this works with [Disposition] = Wrong Number

but what about when [Disposition] = "Wrong Nmber"

or simply put how do I compare when Quotes are part of the text value?

 

[Remou]

It should be ok to include the quotes:

=DCount("[Disposition]","History Query","[Disposition]='""Wrong Number""'")

 

[Jagstrom]

=DCount("[Disposition]","History Query","[Disposition]=""Wrong Number""")

produces 0 result

 

[randy700]

Jagstrom,

You did not copy Remou's code correctly.
Look closely and you'll see single quotes as well as double quotes.


Randy

 

[Jagstrom]

my bad, not sure how I done that but,

Your right

Thanks guys