Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-03-2011, 03:28 PM   #1
johnmerlino
Newly Registered User
 
Join Date: Oct 2010
Posts: 81
Thanks: 0
Thanked 0 Times in 0 Posts
johnmerlino is on a distinguished road
Changing the text value of legends

Hey all,

I found it surprisingly difficult to change the text value of legends when creating a chart on a report. I read in another forum that you have to alter Row Source in Property Sheet. The thing is the Row Source just contains a query:

SELECT [mailer_states_id],Count(*) AS [Count] FROM [mailers] GROUP BY [mailer_states_id];

So this does not allow me to alter anything. What I really want to display is text which I could get at something like this:

SELECT mailer_states.mailer_state,Count(*) As Count FROM mailer_states INNER JOIN mailers ON mailer_states.id = mailers.mailer_states_id GROUP BY mailer_states;

So rather than displaying:
1
2
3

I want to display:
sent
responded
received

Thanks for response.

johnmerlino is offline   Reply With Quote
Old 02-14-2011, 02:38 AM   #2
apr pillai
Newly Registered User
 
apr pillai's Avatar
 
Join Date: Jan 2005
Location: India
Posts: 685
Thanks: 3
Thanked 109 Times in 96 Posts
apr pillai will become famous soon enough
Send a message via AIM to apr pillai Send a message via Yahoo to apr pillai Send a message via Skype™ to apr pillai
Re: Changing the text value of legends

Change the first Column of the Query as follows:

Code:
SELECT Choose(mailer_states.mailer_state,"Sent","Responded","Received") As State,Count(*) As Count FROM mailer_states INNER JOIN mailers ON mailer_states.id = mailers.mailer_states_id GROUP BY mailer_states;
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
(Learn MS-Access Tips and Tricks)

All responses are based on Access2003/2007
apr pillai is offline   Reply With Quote
Reply

Tags
charts , legends , report

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
changing text in a form rwilson32 Modules & VBA 3 07-24-2003 11:08 PM
changing text box value BAzZ Modules & VBA 15 12-11-2002 07:32 AM
Legends in charts SiE Reports 1 05-15-2002 01:21 PM
Changing a text box conditionally hilbertm Modules & VBA 4 09-18-2001 12:15 PM
Legends moleary Reports 8 03-09-2001 01:06 PM




All times are GMT -8. The time now is 09:17 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World