johnmerlino
Registered User.
- Local time
- Today, 16:18
- Joined
- Oct 14, 2010
- Messages
- 81
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.
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.