This is where I'm putting the thing in the design grid and doing the little Label in front of the field CountOfMembers... thing...
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
beaerospace.com
Passion to Innovate. Power to Deliver
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Friday, November 08, 2013 2:40 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] Adding a 'label' to a count query
Would this work?
SELECT Count(CountOfMembers30thJune2009.MemberID) AS "2009 - 2500" FROM CountOfMembers30thJune2009;
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710 Office +1.520.239.4808 | beaerospace.com Passion to Innovate. Power to Deliver
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
Sent: Friday, November 08, 2013 2:37 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Adding a 'label' to a count query
I have a query that counts membership for a given year:
SELECT Count(CountOfMembers30thJune2009.MemberID) AS CountOfMemberID FROM CountOfMembers30thJune2009;
This gives the result: 2500
How do I add a label so that the field shows: "2009 - 2500" ?
Many thanks,
Robin Chapple
------------------------------------
Yahoo Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
------------------------------------
Yahoo Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar