DCOUNT function in a subreport

[Guest]

I have a report with a subreport, that opens based on amacor with specific
date criteria. I need to count the number of times, per group, that there was
an "Exchange Fee" charged. I have typed the function as such:

=DCount("[SERVICE]","[Travelocity Air Travel Service Fee Data]","[SERVICE] =
'EXCHANGE FEE' ")

However it is giving me the total for the entire report not just within my
date range or by group. Each group is listed with the same amount.

 

[Duane Hookom]

If you need to count the number of times a condition/expression is true in a
report, use something like:

=Sum(Abs(condition/expression ))

You might be able to use
=Sum(Abs([SERVICE] = "EXCHANGE FEE"))

 

[Guest]

Thanks that work great, does this expression work if I need to count the
number of times a value is greater than another number?is between tow number?
or is less than another number?

If you need to count the number of times a condition/expression is true in a
report, use something like:

=Sum(Abs(condition/expression ))

You might be able to use
=Sum(Abs([SERVICE] = "EXCHANGE FEE"))

--
Duane Hookom
MS Access MVP

I have a report with a subreport, that opens based on amacor with specific
date criteria. I need to count the number of times, per group, that there
was
an "Exchange Fee" charged. I have typed the function as such:

=DCount("[SERVICE]","[Travelocity Air Travel Service Fee Data]","[SERVICE]
=
'EXCHANGE FEE' ")

However it is giving me the total for the entire report not just within my
date range or by group. Each group is listed with the same amount.

 

[Duane Hookom]

Try it.... This should take less time to test on your own than to ask
someone.


--
Duane Hookom
MS Access MVP

Thanks that work great, does this expression work if I need to count the
number of times a value is greater than another number?is between tow
number?
or is less than another number?

If you need to count the number of times a condition/expression is true
in a
report, use something like:

=Sum(Abs(condition/expression ))

You might be able to use
=Sum(Abs([SERVICE] = "EXCHANGE FEE"))

--
Duane Hookom
MS Access MVP

I have a report with a subreport, that opens based on amacor with
specific
date criteria. I need to count the number of times, per group, that
there
was
an "Exchange Fee" charged. I have typed the function as such:

=DCount("[SERVICE]","[Travelocity Air Travel Service Fee
Data]","[SERVICE]
=
'EXCHANGE FEE' ")

However it is giving me the total for the entire report not just within
my
date range or by group. Each group is listed with the same amount.

 

[Guest]

Thanks, I got it to work with the >=< however it is counting those records
that appear more than (duplicates) once as one single record rather than two.
Is there a way to count the record each time it shows up? I have my control
listed as:

=Sum((Abs([DAYSADV]>=21)))

Try it.... This should take less time to test on your own than to ask
someone.


--
Duane Hookom
MS Access MVP

Thanks that work great, does this expression work if I need to count the
number of times a value is greater than another number?is between tow
number?
or is less than another number?

If you need to count the number of times a condition/expression is true
in a
report, use something like:

=Sum(Abs(condition/expression ))

You might be able to use
=Sum(Abs([SERVICE] = "EXCHANGE FEE"))

--
Duane Hookom
MS Access MVP


I have a report with a subreport, that opens based on amacor with
specific
date criteria. I need to count the number of times, per group, that
there
was
an "Exchange Fee" charged. I have typed the function as such:

=DCount("[SERVICE]","[Travelocity Air Travel Service Fee
Data]","[SERVICE]
=
'EXCHANGE FEE' ")

However it is giving me the total for the entire report not just within
my
date range or by group. Each group is listed with the same amount.

 

[Duane Hookom]

Sorry, I can't see your records so I have no idea what is being duplicated
or why.
--
Duane Hookom
MS Access MVP

Thanks, I got it to work with the >=< however it is counting those records
that appear more than (duplicates) once as one single record rather than
two.
Is there a way to count the record each time it shows up? I have my
control
listed as:

=Sum((Abs([DAYSADV]>=21)))

Try it.... This should take less time to test on your own than to ask
someone.


--
Duane Hookom
MS Access MVP

Thanks that work great, does this expression work if I need to count
the
number of times a value is greater than another number?is between tow
number?
or is less than another number?

:

If you need to count the number of times a condition/expression is
true
in a
report, use something like:

=Sum(Abs(condition/expression ))

You might be able to use
=Sum(Abs([SERVICE] = "EXCHANGE FEE"))

--
Duane Hookom
MS Access MVP


I have a report with a subreport, that opens based on amacor with
specific
date criteria. I need to count the number of times, per group, that
there
was
an "Exchange Fee" charged. I have typed the function as such:

=DCount("[SERVICE]","[Travelocity Air Travel Service Fee
Data]","[SERVICE]
=
'EXCHANGE FEE' ")

However it is giving me the total for the entire report not just
within
my
date range or by group. Each group is listed with the same amount.