Access 2003 Sorting and Grouping ?

I am sorting by “week” in a report on the creation date field that renders all records when I run the report(even records over a week old). I have double checked all aspects of this database. It is a very simple database with NO PROGRAMMING or Macros.

If I need to resort to VBA or Macros so beit.