I have a relatively basic knowledge of Access and am currently using 2002 version.

I am trying to create a Chart using a query that contains a criteria as detailed below. However, when I run the query this works fine but when i run the Chart it pops up with an error and won't do it with this criteria in.

I have a simple logging database that details how many returns are completed on each working day of the month. These are split into periods (e.g 0108 is Jan 08, 0208 is Feb 08 and so on). The Criteria asks you to enter a Period for the data you want to view.

The chart i am creating has X axis labled working Day 1,2,3,4,5 and so on and Y axis labled with total completed.

Please can someone give me an idea on how to create this report based on this criteria