Date errors when grouping on report

[DeveloperMar]

I have a field [ForecastWeekEndDate]in a table defined as a date field (short date).I am trying to group dates ina report by week using the Table Wizard.  I get a compile error (3075) in query expression (INT((ForecastWeekEndDate)-1)\7)\1). What is causing this error?

 

[DougP]

I would instead go into your report and using the sorting and grouping under the &quot;View&quot; menu<br><br>and put this in your group textbox<br>=format(now,&quot;WW&quot <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.