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 reportHi,
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