How to program a GRAPH out of data from TABLE

[taimysho0]

hi, i have a table and i was wondering if i could graph representational data from the table. i have attached an image for example. would something liek this be possible? thanks



my table contains two 2 fields. Site ID's and issue type. Issue types could be "bad protocol", "communication problem" "data gap" and "infrastructure".


the graph will show how many of each issue type out of the total site id's we have. Thanks!

[orange]

Have you considered the Chart Wizard on the Form-->New-->Chart?

Perhaps you could describe what you mean by Graph a little more.

[taimysho0]

I see, Im having trouble making my graph look how i want it to look. I want a line graph that shows Duration on the y axis and Number of IDs for the Duration on the x axis,.



here is my query:

SELECT [not_num_date_create]-[date_sent] AS Duration, Count(notification.record_num) AS [Number of IDs for the Duration]
FROM AMR_exception_all INNER JOIN notification ON AMR_exception_all.[record num] = notification.record_num
GROUP BY [not_num_date_create]-[date_sent]
HAVING ((([not_num_date_create]-[date_sent]) Is Not Null And ([not_num_date_create]-[date_sent])>0) AND ((Count(notification.record_num)) Is Not Null))
ORDER BY Count(notification.record_num);

[taimysho0]

Actually,ill do a pie graph. pic of what i want represented is attached. i want pie graph to show the Duration, and the size of each slice of the pie will be the percentage of the overall Number of sites that falls within that duration.

[taimysho0]

when i try to use the chart wizard i get this error: pic attached

[orange]

What does the output of your query look like? What sort of figures for duration?

[taimysho0]

it looks like this: pic attached



it only shows ONE of the rows, how do i get it to include all the other rows of my query as well??

[taimysho0]

could this be an error with how the chart is set up? or is it a query issue. thanks