How do I change graph legend text

[Shinken]

I want to change the text in the graph legend to read something more descriptive than SumOfABCXXXX. I've tried going to datasheet mode and changing the text, but it doesn't display in Print or Layout mode. How do I do this?

Also, can someone recommend a good book on creating reports in Access, other than just the same-old same-old line reports. I'm just starting w/Access after about 10 years away from writing code and a good text would be very helpful in bringing me up to speed quickly.

Thanks,

Shin

 

[jaxflorida]

Go into the properties of the graph and then into the row source property click the ... button. This puts you into the query for the graph. Go into the SQL statement design view and when it says Select blah, blah, blah as [your legend description here]then look at your report.

Hope this helps.