Creating Charts in Access

[BKGarry]

Hello All,

hoping to pick your collective brains here,

I have never learned how to use Microsoft Access properly (my secondary school could only afford Lotus Approach when i did my GCSEs in 2001) and I have downloaded the Microsoft Desktop Call Tracker for our Reception staff to use. I have pretty much adapted this for our own personal needs, but there is one thing we would like, and I just can't seem to figure out how to do it. I have setup a query table that shows all calls between a specified date, but what we would like is for it to Produce a pie Chart from the "Status" column/field. At the moment I can copy and paste it into excel where it does some nice CountIF's and creates the chart, but all I would like it to do is count the Amount of Active, Closed and Overdue calls in that period and make the Pie chart in Access.

Could anyone shed some light on how to do this (step by step please) so that I can get this one snigly little bit working.

Thank you very much

Garry

[SYNACK]

This of any help:

[BKGarry]

that's good @SYNACK but again I am stuck with the fact the values are Text and not Numerical, i will fiddle tomorrow me thinks

[SYNACK]

Just use a formula like the countifs in a new query that converts it into numbers then use that as the data source.

[BKGarry]

Just use a formula like the countifs in a new query that converts it into numbers then use that as the data source.

I will try in the morning. Thank you again

[BKGarry]

Update,

It worked, but only for a pie chart with a count of the text values, no percentages. but yay it worked. Thank you @SYNACK