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?

id preferably like to do this without exporting to excel

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.

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]);

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?