ACCESS FEED: RE: [MS_AccessPros] Adding a 'label' to a count query

Senin, 11 November 2013

RE: [MS_AccessPros] Adding a 'label' to a count query

Yahoo! Me too. Not only that, but I forget things that I've done successfully. Inconvenient. :-)

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 8:48 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Adding a 'label' to a count query

Thanks Liz,

My apology. I did not explain properly. I am an aged self taught amateur and often use incorrect descriptions.

That gives me what I call a 'field header'. I was planning that the field should show - "2009 - 2005". I expect the "2009 - " to be part of an expression that includes the variable content of the field.

I experimented again and this:

SELECT "2009 - "& Count(CountOfMembers30thJune2009.MemberID) AS CountOfMemberID FROM CountOfMembers30thJune2009;

gives the result needed.

Thanks for your help.

Robin CVhapple

At 9/11/2013 08:41 AM, you wrote:
>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.
>
>
>
>------------------------------------
>
>Yahoo Groups Links
>
>
>

------------------------------------

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.