Unstable & Quirky graphs in Access

[VanRoekel.Clint]

We are using Access 2003 on a Windows XP Pro machine and graphs from the database are very unreliable. Can anyone explain why the first date along the x-axis would be displayed in "d-mmm" format and all the rest of the dates would be in the format "m/d"? "m/d" is what I use in the query:

SELECT Format([LastDay],"m/d") as md,format([Weight],"0.00%") as Score ,[TotalResponses] as [# Responses] FROM [qryGraph] where [FieldName]=[CurrentQuestion];

 

[VanRoekel.Clint]

Unstable & Quirky

Here is what the graphs look like....see attached jpg.....