When trying to create a chart displaying weeks, I keep getting a lump sum of month(s). The input into my table is on a daily basis with several inputs a day. I made a query to group days into Week Begining (WkBeg)on a sunday. On my form I have a StartDate and EndDate for the user to input a date range, which is listed as critera for (WkBeg)query. When the chart pops up it shows the entire number of days into one column or months. When I design my chart and drag the WkBeg label to the chart axis and it turns it into months. I want to chart the weeks entered into the Form's StartDate and EndDate.

Please Help

Thanx in advance