Hi Ali,
> Follow up to this email. when I checked to see what the actual sql was > doing it was: > > INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/5/2005, > 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) I think Access is interpreting your dates as arithmetic expressions, then converting the result of the expression into a string to store in the database. If you work out 8 / 5 / 2005 with a calculator (8 divided by 5, divided by 2005) you'll see what I mean! Jason ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
