Access Report problem

[mchang]

I have a query that show in a report a date column. running the query the date column is populated correctly but the report show it wrong.

query:
8/12/2008
8/13/2008
8/12/2008
8/11/2008
8/11/2008

report:
8/12/2008
8/12/2008
8/12/2008 .....
I have checked the fields, the source and everything seens to be ok, but the problem is still here. Can anyone help me?

[janders468]

It's hard to say what could be causing this, could you post the SQL for the record source of your report, or if it uses a query directly could you post the SQL to that?