graph

[Joel Allen]

Hello,

I have a graph report. I brought in my fields and it works fine.

I want to bring in another field from my query to put it in the header and
it's not available from the list of fields. Why is that? How can I pull in
this extra field into my header?

Thanks,
Joel

 

[Al Campagna]

Joel,
You should be able to use the query behind the report to bring in the field you want.
Or even a control that references an open form, or even a calculated field.
Then place a text control on top of the chart with that value. Bring to Front, and it
will display the value as though it was actually on the chart.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."