Re: [MSAccessProfessionals] Count records on a report

What is the data type of the age and what is the calculation?

Duane

Sent from my mobile

On Jul 12, 2020, at 9:03 PM, M Garcia via groups.io <toukey1=yahoo.com@groups.io> wrote:

 Thanks for the response below.

I am getting #Error. Is it because the Age field is a calculated field?

Regards

On Jul 12, 2020, at 9:42 PM, Duane Hookom <duanehookom@hotmail.com> wrote:



Hi Toukey,

You can add a text box with a control source of:

=Abs(Sum([Age]>25))

Regards,

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of M Garcia via groups.io <toukey1=yahoo.com@groups.io>
Sent: Sunday, July 12, 2020 8:35 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Count records on a report

 

Hi,

I have a report that list names and ages.  How can I count the number of persons that are over 25?

Regards
Toukey