Chart - Count of value

[libraccess]

I have done this before but it just will not work

attch file. I want to add a count to the chart - every time I add the Count to the query fine, I save the query and reopen and the count has gone
also the format of the number I set to Fixed zero dec places, run the query it works and again when the query is closed and reopened to format has gone ??



any clues

,Attachment 9633

[June7]

The chart RowSource is a crosstab query pivoting on the Destination. How would you include the count? How would it display on chart?

The decimal setting in the query properties does nothing. Setting the field in the chart data table to Number and 0 decimals looks correct in Design view but not in other views. Mysterious.

[libraccess]

mmmm one for me to go back to on a rainy day