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

Jumat, 08 November 2013

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