Formula ,
Such is the nature of graphs in Access.
The "design display" shows the initial design values, and does not
display updated or changed graph values... during the development process.
The graph's internal spreadsheet doesn't refresh after changes from the
initial values.
In order to "update" the design view, run the query behind the graph,
and
then cut & paste the query values into the graph's spreadsheet. The design
view of the graph
should now be updated.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."
