DCOUNTA & wildcards
Try
="<1~*"
--
Regards,
Peo Sjoblom
"Paul Dennis" wrote in message
...
How would this work to exclude it. I have tried <"=1~*" but it doesn't
seem
to work.
"Peo Sjoblom" wrote:
Use this as criteria
="=1~*"
will only find 1*
--
Regards,
Peo Sjoblom
"Paul Dennis" wrote in message
...
thanks for this, however this will find 1*xxxx, how do you check for a
space
after the *.
"Muhammed Rafeek M" wrote:
if you want use * as a character use ~ infront of *
eg: 1~*
please do rate
"Paul Dennis" wrote:
I need to do a DCOUNTA on a field looking for value 1*
How do I do this when 1* is a wildcard ?
|