[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

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 4

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___