#error in a report (1 Viewer)

[kkulick]

I'm trying to group different section of a report header by the week ending date. I have tried putting =DateAdd("d",6-Weekday(Now()),Now()) in. It works, but it gives me the same week ending in every group, nothing unique to every group. If I drag my date field in the header it gives me the last date of the week that is grouped. So I then tried using this, =DateAdd("d",(Weekday([Date])-2)*-1,Now()), but I get an #error that shows on the report. Does anyone have any other ideas how I can get a week ending to group different weeks on a page. Thanks

 

[Pat Hartman]

In the report's sorting and grouping properties, you can specify week as an option when you are grouping by a date field.

 

[kkulick]

Pat, I've tried that also. I can get it to group by the week, but when I put the equation in that I mentioned earlier, it does not update for each group like the date does. Have an idea? Thanks.

 

[Pat Hartman]

Do the calculation in an unbound field. Hide the week number field that you are using for sorting and grouping if you don't want to see it.

Use the Date() function rather than Now() in the calculation since you are not concerned with time.

 

[kkulick]

thanks again, but that still didn't work. I don't know what to do with this.