DCount

[Travis Jones]

In a group footer in my report, my Count functions are
only counting the grouped data, but my DCount functions
are totalling the entire domain (my record source), not
just the section grouped in the report. Is there some way
to get the DCount functions to only total the grouped
section?

Thanks,

Travis

 

[fredg]

In a group footer in my report, my Count functions are
only counting the grouped data, but my DCount functions
are totalling the entire domain (my record source), not
just the section grouped in the report. Is there some way
to get the DCount functions to only total the grouped
section?

Thanks,

Travis

Travis,
DCount is supposed to count all the records in the table, UNLESS you
have used some criteria in the DCount Where clause argument to
restrict data.

What's wrong with using Count() in the Group Footer to count the
records in the group?

 

[Duane Hookom]

I agree with Fred. You can easily add a condition/where to your count if you
need. We would need to see your DCount() in order to help further.

 

[Travis Jones]

-----Original Message-----

Travis,
DCount is supposed to count all the records in the table, UNLESS you
have used some criteria in the DCount Where clause argument to
restrict data.

What's wrong with using Count() in the Group Footer to count the
records in the group?
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
.

The field I am counting is yes/no, and with the DCount I
am trying to count only the yeses in a group. Do you have
any idea how to make that work?

Thanks,

Travis

 

[carol]

yes, i too am having problems with this function in the
report total section. here is what i have....

=DCount([Complete Documentation],[item data],"Yes")

where complete documentation is the field (yes/no), and
item data is the table and "yes" is the condition.

would appreciate any advice that you can give.

 

[Travis Jones]

Carol,

Duane gave me a potential solution, try =Sum(abs([item
data)).

It solved my problem, and it involved a yes/no field.

I hope this helps.

Travis

-----Original Message-----
yes, i too am having problems with this function in the
report total section. here is what i have....

=DCount([Complete Documentation],[item data],"Yes")

where complete documentation is the field (yes/no), and
item data is the table and "yes" is the condition.

would appreciate any advice that you can give.

-----Original Message-----
In a group footer in my report, my Count functions are
only counting the grouped data, but my DCount functions
are totalling the entire domain (my record source), not
just the section grouped in the report. Is there some way
to get the DCount functions to only total the grouped
section?

Thanks,

Travis
.

.

 

[carol]

to clarify, the yes/no is a check box field from the
table. thx.

-----Original Message-----
yes, i too am having problems with this function in the
report total section. here is what i have....

=DCount([Complete Documentation],[item data],"Yes")

where complete documentation is the field (yes/no), and
item data is the table and "yes" is the condition.

would appreciate any advice that you can give.

-----Original Message-----
In a group footer in my report, my Count functions are
only counting the grouped data, but my DCount functions
are totalling the entire domain (my record source), not
just the section grouped in the report. Is there some way
to get the DCount functions to only total the grouped
section?

Thanks,

Travis
.

.

 

[carol]

thx for your help, but it didn't work. i am using a
checkbox field-yes/no so don't know if that's the problem
or not.

carol

-----Original Message-----
Carol,

Duane gave me a potential solution, try =Sum(abs([item
data)).

It solved my problem, and it involved a yes/no field.

I hope this helps.

Travis

-----Original Message-----
yes, i too am having problems with this function in the
report total section. here is what i have....

=DCount([Complete Documentation],[item data],"Yes")

where complete documentation is the field (yes/no), and
item data is the table and "yes" is the condition.

would appreciate any advice that you can give.

-----Original Message-----
In a group footer in my report, my Count functions are
only counting the grouped data, but my DCount functions
are totalling the entire domain (my record source), not
just the section grouped in the report. Is there some way
to get the DCount functions to only total the grouped
section?

Thanks,

Travis
.

.

.

 

[Duane Hookom]

Carol,
Next time please explain what you mean by "it didn't work". If you have a
yes/no field in your report's record source and you want to count the number
of "yes" values:
Add a text box in the report Header or Footer with a control source of
=Sum(Abs([YesNoField]))

--
Duane Hookom
MS Access MVP

thx for your help, but it didn't work. i am using a
checkbox field-yes/no so don't know if that's the problem
or not.

carol

-----Original Message-----
Carol,

Duane gave me a potential solution, try =Sum(abs([item
data)).

It solved my problem, and it involved a yes/no field.

I hope this helps.

Travis

-----Original Message-----
yes, i too am having problems with this function in the
report total section. here is what i have....

=DCount([Complete Documentation],[item data],"Yes")

where complete documentation is the field (yes/no), and
item data is the table and "yes" is the condition.

would appreciate any advice that you can give.


-----Original Message-----
In a group footer in my report, my Count functions are
only counting the grouped data, but my DCount functions
are totalling the entire domain (my record source), not
just the section grouped in the report. Is there some
way
to get the DCount functions to only total the grouped
section?

Thanks,

Travis
.

.

.

 

[carol]

sorry duane,

this is what i have as the property for the field in the
report footer:
=Sum(Abs([YesNoField]))

it is returning a checkbox with YES. i need a count of
all checkboxes = YES. report is not grouped on this item
and field is located within detail area of report. i have
tried all of the running sum settings but still get the
same results. this is needed for a work related project
which i need to complete today. hope someone can resolve
my problem. thx, your support system is awesome!