I am trying to create a chart in a report based on a query. My query runs after I select a date range and the customer's name from a dialog box and it comes up with four fields: Customers name, Date, Department and Purchase Total. Now I am trying to create a column chart that has the Date and the Purchase Total. For each Date there is more than one Department and I would like that to show in those columns but it wouldn't work. Through the wizard I choose the three fields (Date, Purchase total and Department) but when I run it I get an error message; something like Microsoft Jet Database doesn't recognize one of the fields in the dialog box that I use to select the Name and Date range)! I don't understand what's that supposed to mean. When I change the Chart to a Line chart or I select only two fields from my query it does work.
Would please let me what am I doing wrong? this is driving me crazy. Thank you