Using =Count(*)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to take the total # of records (conferences held) in a report and and
subtract (conferences waived) and (conferences cancelled)?
I tried =Sum(Abs([Count(*)]-[Conference Cancelled]-[Conference Waived])) in
the report footer but that does not seem to work? I appreciate any thoughts.
Thanks.
 
Do you expect us to know how your tables and data are structured? Do you
have sample records you could share?
 
Assumption:
Conference Cancelled and Conference Waived are boolean fields (Yes/No)

=Count(*)+ Sum([Conference Cancelled]) + Sum([Conference Waived])
 
Sorry, I'm new at this. In my report footer I'm trying to take the total #
of records which I capture with =Count(*) and subtract the 2 totals below? I
hope that makes sense? Thanks for you quick reply.

=Sum([Conference Cancelled])*-1 =Sum([Conference Waived])*-1

Duane Hookom said:
Do you expect us to know how your tables and data are structured? Do you
have sample records you could share?

--
Duane Hookom
MS Access MVP
--

Nick said:
I want to take the total # of records (conferences held) in a report and
and
subtract (conferences waived) and (conferences cancelled)?
I tried =Sum(Abs([Count(*)]-[Conference Cancelled]-[Conference Waived]))
in
the report footer but that does not seem to work? I appreciate any
thoughts.
Thanks.
Click to expand...
Click to expand...
 
Try:
=Count(*) - (Sum(Abs([Conference Cancelled])) + Sum(Abs([Conference
Waived])) )
--
Duane Hookom
MS Access MVP
--

Nick said:
Sorry, I'm new at this. In my report footer I'm trying to take the total
#
of records which I capture with =Count(*) and subtract the 2 totals below?
I
hope that makes sense? Thanks for you quick reply.

=Sum([Conference Cancelled])*-1 =Sum([Conference Waived])*-1

Duane Hookom said:
Do you expect us to know how your tables and data are structured? Do you
have sample records you could share?

--
Duane Hookom
MS Access MVP
--

Nick said:
I want to take the total # of records (conferences held) in a report and
and
subtract (conferences waived) and (conferences cancelled)?
I tried =Sum(Abs([Count(*)]-[Conference Cancelled]-[Conference
Waived]))
in
the report footer but that does not seem to work? I appreciate any
thoughts.
Thanks.
Click to expand...
Click to expand...
Click to expand...
 
I cut and pasted that in and it worked!! Thanks Much.

John Spencer said:
Assumption:
Conference Cancelled and Conference Waived are boolean fields (Yes/No)

=Count(*)+ Sum([Conference Cancelled]) + Sum([Conference Waived])


Nick said:
I want to take the total # of records (conferences held) in a report and
and
subtract (conferences waived) and (conferences cancelled)?
I tried =Sum(Abs([Count(*)]-[Conference Cancelled]-[Conference Waived]))
in
the report footer but that does not seem to work? I appreciate any
thoughts.
Thanks.
Click to expand...
Click to expand...
 
Back
Top