Senin, 13 Juli 2020

Re: [MSAccessProfessionals] Count records on a report

Only just got some time to confirm this.  Yes moving the text box to the Report footer resolved the error.

Thanks again for your assistance.

Regards



On Monday, July 13, 2020, 10:29:19 AM AST, Duane Hookom <duanehookom@hotmail.com> wrote:


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