DCOUNTA & wildcards
 

I need to do a DCOUNTA on a field looking for value 1*

How do I do this when 1* is a wildcard ?

DCOUNTA & wildcards
 

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 ?

DCOUNTA & wildcards
 

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 ?

DCOUNTA & wildcards
 

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 ?

DCOUNTA & wildcards
 

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 ?

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 ?

DCOUNTA & wildcards
 

didn't work - sorry

"Peo Sjoblom" wrote:

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 ?