Senin, 13 Juli 2020

Re: [MSAccessProfessionals] Count records on a report

Toukey,

Is your issue resolved?

Regards,
Duane


From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of M Garcia via groups.io <toukey1=yahoo.com@groups.io>
Sent: Monday, July 13, 2020 8:52 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Count records on a report
 
Thanks Duane


On Jul 13, 2020, at 8:52 AM, Duane Hookom <duanehookom@hotmail.com> wrote:


Hi Toukey,

You will get an #Error if you place the text box in a Page header or footer. Placing the calculation in a report or group header or footer should work.

Your age calculation looks like at any given date, one half might be a year off. 

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 10:40 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Count records on a report
 
I'm calculating the Age in the report query - : Age: IIf(IsNumeric([custidnum]),Year(Now())-Left([custidnum],4),0) 

I am extracting the first 4 numbers from the id number, which is the year, and subtract it from the current year to come up with the age.



On Sunday, July 12, 2020, 11:17:27 PM AST, Duane Hookom <duanehookom@hotmail.com> wrote:


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

Tidak ada komentar:

Posting Komentar