Senin, 13 Juli 2020

Re: [MSAccessProfessionals] Count records on a report

If your report's record source has duplicate id numbers, any count will include the duplicates. To avoid this, you can typically use a Running Sum text box in a group section.

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 3:17 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Count records on a report
 
Just a quick question before this issue is closed.

If the report had duplicate id numbers for example and you group by id numbers on the report so that you get unique id numbers, if you do a count, would it include the id numbers that are not shown?


Regards



On Monday, July 13, 2020, 04:12:37 PM AST, M Garcia via groups.io <toukey1=yahoo.com@groups.io> wrote:


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