DCount

  • Thread starter Thread starter Travis Jones
  • Start date Start date
T

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
 
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
Click to expand...
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?
 
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.
 
-----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.
.
Click to expand...
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
 
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.
 
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
.
Click to expand...
.
Click to expand...
 
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
.
Click to expand...
.
Click to expand...
 
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
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
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


carol said:
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
.

.
Click to expand...
.
Click to expand...
Click to expand...
 
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!
 
Back
Top