Data Gathering From Report

  • Thread starter Thread starter NigelP
  • Start date Start date
N

NigelP

On my report I have field that can only have two options
HM and RECV I would like to know the code to enable the
report to count how many times HM appears and how many
times RECV appears.
 
On my report I have field that can only have two options
HM and RECV I would like to know the code to enable the
report to count how many times HM appears and how many
times RECV appears.
Click to expand...

Add two unbound controls to the report (but not in the Page Footer).

Set one control source to:
=Sum(IIf([fieldName] = "HM",1,0))

Set the other control source to:
=Sum(IIf([fieldName] = "RECV",1,0))
 
Thanx fred,
is it possible to use this new control source to add up a
total between two sub reports and display it on the main
report.
-----Original Message-----
On my report I have field that can only have two options
HM and RECV I would like to know the code to enable the
report to count how many times HM appears and how many
times RECV appears.
Click to expand...

Add two unbound controls to the report (but not in the Page Footer).

Set one control source to:
=Sum(IIf([fieldName] = "HM",1,0))

Set the other control source to:
=Sum(IIf([fieldName] = "RECV",1,0))

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top