Counting Records

  • Thread starter Thread starter Jaycee
  • Start date Start date
J

Jaycee

I want to count the number of records in a report, then
calculate the percentage of those records that meet
certain criteria.

Do-able?

Thanks,

Jaycee
 
Add a text box to the report header or footer. Set the control source to:
=Count(*)
For a certain criteria:
=Sum(Abs([Certain Criteria]))
 
OK, first step worked. Second step worked when I entered
only one criteria; however, I need to set more than one.

The report contains true/false values for several fields
per employee (professional certifications). Some
employees have one certification, others multiple, others
none. I need to calculate the percentage of employees
who have one or more certifications.

My post titled Horizontal Totals is related to the same
report.

Thanks for your help.

Jaycee
-----Original Message-----
Add a text box to the report header or footer. Set the control source to:
=Count(*)
For a certain criteria:
=Sum(Abs([Certain Criteria]))

--
Duane Hookom
Microsoft Access MVP


I want to count the number of records in a report, then
calculate the percentage of those records that meet
certain criteria.

Do-able?

Thanks,

Jaycee
Click to expand...


.
Click to expand...
 
I don't believe in totaling horizontally since tables aren't normalized. You
could however leave your tables un-normalized and use any expression that
calculates to either or true or false.

--
Duane Hookom
MS Access MVP


Jaycee said:
OK, first step worked. Second step worked when I entered
only one criteria; however, I need to set more than one.

The report contains true/false values for several fields
per employee (professional certifications). Some
employees have one certification, others multiple, others
none. I need to calculate the percentage of employees
who have one or more certifications.

My post titled Horizontal Totals is related to the same
report.

Thanks for your help.

Jaycee
-----Original Message-----
Add a text box to the report header or footer. Set the control source to:
=Count(*)
For a certain criteria:
=Sum(Abs([Certain Criteria]))

--
Duane Hookom
Microsoft Access MVP


I want to count the number of records in a report, then
calculate the percentage of those records that meet
certain criteria.

Do-able?

Thanks,

Jaycee
Click to expand...


.
Click to expand...
Click to expand...
 
If I promise not to sum horizontally, would you help me
with the expression that would calculate the percentage
of employees with one or more certifications?

Thanks!
-----Original Message-----
I don't believe in totaling horizontally since tables aren't normalized. You
could however leave your tables un-normalized and use any expression that
calculates to either or true or false.

--
Duane Hookom
MS Access MVP


OK, first step worked. Second step worked when I entered
only one criteria; however, I need to set more than one.

The report contains true/false values for several fields
per employee (professional certifications). Some
employees have one certification, others multiple, others
none. I need to calculate the percentage of employees
who have one or more certifications.

My post titled Horizontal Totals is related to the same
report.

Thanks for your help.

Jaycee
-----Original Message-----
Add a text box to the report header or footer. Set the control source to:
=Count(*)
For a certain criteria:
=Sum(Abs([Certain Criteria]))

--
Duane Hookom
Microsoft Access MVP


"Jaycee" <[email protected]> wrote
Click to expand...
in
message
I want to count the number of records in a report, then
calculate the percentage of those records that meet
certain criteria.

Do-able?

Thanks,

Jaycee


.
Click to expand...
Click to expand...


.
Click to expand...
 
In any group or report footer, you should be able to use an expression like:
=Sum(Abs(Nz(fldA,0) + Nz(FldB,0) + Nz(FldC,0) >=1))/Count(*)

--
Duane Hookom
MS Access MVP


Jaycee said:
If I promise not to sum horizontally, would you help me
with the expression that would calculate the percentage
of employees with one or more certifications?

Thanks!
-----Original Message-----
I don't believe in totaling horizontally since tables aren't normalized. You
could however leave your tables un-normalized and use any expression that
calculates to either or true or false.

--
Duane Hookom
MS Access MVP


OK, first step worked. Second step worked when I entered
only one criteria; however, I need to set more than one.

The report contains true/false values for several fields
per employee (professional certifications). Some
employees have one certification, others multiple, others
none. I need to calculate the percentage of employees
who have one or more certifications.

My post titled Horizontal Totals is related to the same
report.

Thanks for your help.

Jaycee

-----Original Message-----
Add a text box to the report header or footer. Set the
control source to:
=Count(*)
For a certain criteria:
=Sum(Abs([Certain Criteria]))

--
Duane Hookom
Microsoft Access MVP


message
I want to count the number of records in a report, then
calculate the percentage of those records that meet
certain criteria.

Do-able?

Thanks,

Jaycee


.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top