are charts possible in access

[oohmygod831]

i need the results from a query to be displayed in graphical form ie bar chart or pie chart. is this possible in access and if so how?

 

[oohmygod831]

id preferably like to do this without exporting to excel

 

[boblarson]

Yes, you can do graphing in Access.

Go here for tutorials on that:
http://www.functionx.com/access/index.htm

Look down the list for charts.

 

[oohmygod831]

doesnt seem to work with my query as i get the user to enter a date and the results are based on that date entered. here is the query

SELECT Shift.Field1, Sum(Main.Shift) AS SumOfShift
FROM Shift INNER JOIN Main ON Shift.ID = Main.Shift
WHERE (((Month([main].[date]))=([ENTER MONTH])))
GROUP BY Shift.Field1, Shift.ID, Month([Date]);

 

[oohmygod831]

Im sorry to be a pain but ive just realised that it shows the chart when im in design view but not when im in form view? why not?