Minggu, 12 Juli 2020

Re: [MSAccessProfessionals] Count records on a report

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

Tidak ada komentar:

Posting Komentar