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

Re: [MSAccessProfessionals] Count records on a report

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

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

Re: [MSAccessProfessionals] Count records on a report

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

[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

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115664) | Reply To Group | Reply To Sender | Mute This Topic | New Topic

Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

[AccessDevelopers] Just one minute a day, give yourself a chance to get rich. Zero risk, no investment, no credit card required

 

unsubscribe

Hi Friends,
If you have a cell phone, know how to install an app. and want a stable income with unlimited opportunity in the near future, you are in the RIGHT PLACE at the RIGHT TIME to join us.
You do not need to sell anything, No inventory. No deliveries. No collecting payments. No meetings. No bugging friends. There are no fees to purchase, no quotas, and no limits, no credit card, even no financial commitment required.
You only need to take less than 5 seconds daily. Free training is included.
No Cost, NO credit card required, No Risk, No Hazard
What have you got to lose?

Is the new cryptocurrency PI Network another scam or legit?
If you miss the bitcoin at early stage, don't let this opportunity pass by again.
Just one minute a day, give yourself a chance to get rich.
Zero risk, no investment, no credit card required
Just visit us at
https://www.pinetworkapp.org
or
https://minepi.com/cakzxd

__._,_.___

---

Posted by: "theafollowing0601@yahoo.com" <theafollowing0601@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Please zip all files prior to uploading to Files section.

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___

[belajar-access] File - Tata Tertib dan Aturan.txt

 

Tata tertib dan peraturan
Mailing List: belajar-access@yahoogroups.com

1. Mailing list ini membahas mengenai pemrograman Microsoft Access.
2. Tidak diperkenankan mem-posting topik yang tidak ada kaitannya sama sekali dengan pemrograman MS Access, peluang kerja atau tawaran kerja sama dengan keahlian di bidang MS Access, atau pengajaran/kursus MS Acces. Pelanggaran terhadap aturan ini akan di-ban dari keanggotaan milis ini.
3. Mohon berdiskusi dengan baik, dengan semangat membangun, demi kemajuan kita bersama. Hindarilah perbantahan (flame) yang bisa menjadi pertengkaran yang tidak perlu.
4 Hindari reply permintaan one-liner seperti 'saya minta juga dong', 'saya setuju', dan lain-lain yang tidak perlu.
5. Sedapat mungkin memberikan data-data yang lengkap dalam mengajukan suatu masalah untuk memudahkan rekan-rekan sesama member mengidentifikasi dan mencarikan solusi, termasuk memberikan subject yang sesuai dengan isi email, tidak dengan kata-kata seperti "tologing dong", "pusing...", "ada yang bisa bantu..", dll.

Moderator

__._,_.___

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (160)

SPAM IS PROHIBITED

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___