DCount Wildcard???

[BARKAROO]

I've created a query (to create a report) that pulls a variety of
"descriptions" (construction types).

I'm using the following expression to count the number of times a particular
description is returned from a query. In this case, the description type is
"RENO":

=Sum(Abs([Description]="RENO"))

So far everything is working.... except, I have some descriptions that start
with the description type and then specify - for example:

RENO: ADD DOORWAY
RENO: BASEMENT
RENO: REMOVE WALL

When I use my expression,
=Sum(Abs([Description]="RENO"))
It doesn't acknowledge anything other than what is actually in the
expression... that is, it doesn't recognize that there are different "RENO"s.
Is there a wild card that I can use in my expression so that all of the
"RENO"s will be retrieved?
Hope this makes sense.

Any help would be greatly appreciated.

Thanks.
Barkaroo.

 

[Tom Lake]

I've created a query (to create a report) that pulls a variety of
"descriptions" (construction types).

I'm using the following expression to count the number of times a
particular
description is returned from a query. In this case, the description type
is
"RENO":

=Sum(Abs([Description]="RENO"))

So far everything is working.... except, I have some descriptions that
start
with the description type and then specify - for example:

RENO: ADD DOORWAY
RENO: BASEMENT
RENO: REMOVE WALL

When I use my expression,
=Sum(Abs([Description]="RENO"))
It doesn't acknowledge anything other than what is actually in the
expression... that is, it doesn't recognize that there are different
"RENO"s.
Is there a wild card that I can use in my expression so that all of the
"RENO"s will be retrieved?
Hope this makes sense.

Any help would be greatly appreciated.

Try this:

=Sum(Abs([Description] Like"RENO*"))

Tom Lake

 

[Marshall Barton]

I've created a query (to create a report) that pulls a variety of
"descriptions" (construction types).

I'm using the following expression to count the number of times a particular
description is returned from a query. In this case, the description type is
"RENO":

=Sum(Abs([Description]="RENO"))

So far everything is working.... except, I have some descriptions that start
with the description type and then specify - for example:

RENO: ADD DOORWAY
RENO: BASEMENT
RENO: REMOVE WALL

When I use my expression,
=Sum(Abs([Description]="RENO"))
It doesn't acknowledge anything other than what is actually in the
expression... that is, it doesn't recognize that there are different "RENO"s.
Is there a wild card that I can use in my expression so that all of the
"RENO"s will be retrieved?

To use a wildcard xomparison, you have to use the Like
operator instead of =

=Sum(Abs([Description] LIKE "RENO*"))

 

[Duane Hookom]

Or....
=Sum(Abs(Left([Description],4)="RENO"))

 

[BARKAROO]

Duane, what does the "4" in your expresson do?

Or....
=Sum(Abs(Left([Description],4)="RENO"))


--
Duane Hookom
MS Access MVP
--

I've created a query (to create a report) that pulls a variety of
"descriptions" (construction types).

I'm using the following expression to count the number of times a
particular
description is returned from a query. In this case, the description type
is
"RENO":

=Sum(Abs([Description]="RENO"))

So far everything is working.... except, I have some descriptions that
start
with the description type and then specify - for example:

RENO: ADD DOORWAY
RENO: BASEMENT
RENO: REMOVE WALL

When I use my expression,
=Sum(Abs([Description]="RENO"))
It doesn't acknowledge anything other than what is actually in the
expression... that is, it doesn't recognize that there are different
"RENO"s.
Is there a wild card that I can use in my expression so that all of the
"RENO"s will be retrieved?
Hope this makes sense.

Any help would be greatly appreciated.

Thanks.
Barkaroo.

 

[Tom Lake]

Duane, what does the "4" in your expresson do?

Or....
=Sum(Abs(Left([Description],4)="RENO"))

I'm not Duane but Left([Description],4) chooses the leftmost 4 characters
out of the Description field. The expression

Left([Description],4)="RENO"

is True (-1) if the leftmost four characters are "RENO" and False (0)
otherwise. The Abs takes the -1 and makes it positive
and leaves the 0 alone.

So we have

Abs(Left([Description],4)="RENO")

which is 1 if Description starts with "RENO"

and 0 if not. The Sum will sum up all the ones and therefore give a count
of all the fields that start with "RENO".

Tom Lake

 

[Duane Hookom]

Thanks Tom. I couldn't have explained it better

--
Duane Hookom
MS Access MVP

Duane, what does the "4" in your expresson do?

Or....
=Sum(Abs(Left([Description],4)="RENO"))

I'm not Duane but Left([Description],4) chooses the leftmost 4 characters
out of the Description field. The expression

Left([Description],4)="RENO"

is True (-1) if the leftmost four characters are "RENO" and False (0)
otherwise. The Abs takes the -1 and makes it positive
and leaves the 0 alone.

So we have

Abs(Left([Description],4)="RENO")

which is 1 if Description starts with "RENO"

and 0 if not. The Sum will sum up all the ones and therefore give a count
of all the fields that start with "RENO".

Tom Lake

 

[BARKAROO]

Thanks.

Thanks Tom. I couldn't have explained it better

--
Duane Hookom
MS Access MVP

Duane, what does the "4" in your expresson do?

:

Or....
=Sum(Abs(Left([Description],4)="RENO"))

I'm not Duane but Left([Description],4) chooses the leftmost 4 characters
out of the Description field. The expression

Left([Description],4)="RENO"

is True (-1) if the leftmost four characters are "RENO" and False (0)
otherwise. The Abs takes the -1 and makes it positive
and leaves the 0 alone.

So we have

Abs(Left([Description],4)="RENO")

which is 1 if Description starts with "RENO"

and 0 if not. The Sum will sum up all the ones and therefore give a count
of all the fields that start with "RENO".

Tom Lake