I have a problem with using strings as criteria in the database function
DCOUNT. If I use a criterium such as "loc1", it counts all the locations
starting with "loc1", so also "loc10", "loc1b" "loc11". For example:
=dcount(database;criteria) return 3, where it would like it to return 1

criteria:
location name
loc1 a

database:
location name
loc1 a
loc10 a
loc10 a

I know i could prevent it by using loc01, but i would like to know if there
is a button or switch somewhere that also does the trick. And does anyone
know if this function perforedm differently in older version of excel?
(pre-2000)

Use this instead of

loc1

="=loc1"


will return 1


--


Regards,


Peo Sjoblom



"Rob" wrote in message
...
I have a problem with using strings as criteria in the database function
DCOUNT. If I use a criterium such as "loc1", it counts all the locations
starting with "loc1", so also "loc10", "loc1b" "loc11". For example:
=dcount(database;criteria) return 3, where it would like it to return 1

criteria:
location name
loc1 a

database:
location name
loc1 a
loc10 a
loc10 a

I know i could prevent it by using loc01, but i would like to know if
there
is a button or switch somewhere that also does the trick. And does anyone
know if this function perforedm differently in older version of excel?
(pre-2000)

Thanks! (why didn't I think of that)

Regards,

"Peo Sjoblom" wrote:

Use this instead of

loc1

="=loc1"


will return 1


--


Regards,


Peo Sjoblom



"Rob" wrote in message
...
I have a problem with using strings as criteria in the database function
DCOUNT. If I use a criterium such as "loc1", it counts all the locations
starting with "loc1", so also "loc10", "loc1b" "loc11". For example:
=dcount(database;criteria) return 3, where it would like it to return 1

criteria:
location name
loc1 a

database:
location name
loc1 a
loc10 a
loc10 a

I know i could prevent it by using loc01, but i would like to know if
there
is a button or switch somewhere that also does the trick. And does anyone
know if this function perforedm differently in older version of excel?
(pre-2000)