How to add Week Number in a report?

[wdacc]

Hi there,

If I have a reort which has date and parts, how can I sort the date in a range and have week number on the report?

eg. Date from 1/1/2004 to 3/1/2004 parts records show from date to date, I want week 1 of 2004 showing part records and week 2 of 2004 showing,...etc.
Please write in detail, thaks.

 

[glalsop]

When you set the Group up for your date field, you can change the 'Group On' option to 'Week'.

Good luck

-Gary

 

[randysmid]

Hi,
There is a function called "DatePart". Try adding this to your report temporarily (Control Source for a text box):
=DatePart("ww",Now())

HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association