Marc, I use the weeks extensivly in my reports and achieve this by using the Format([StartDate],"ww\-yyyy",2,2) function in the underlying queries.
The regional settings (Windows) will also allow you to set the first week of the years start date and also to define the first day of the week (i.e. Sun or Mon). Hope this helps. >From: "Pete Harrison" <[EMAIL PROTECTED]> >Reply-To: [email protected] >To: [email protected] >Subject: [AccessDevelopers] Re: Group by week >Date: Tue, 30 Aug 2005 08:57:29 -0000 > >Marc, > >We would need to see an example of the table fields to understand >how this can be achieved. > >Regards >Pete > >--- In [email protected], [EMAIL PROTECTED] wrote: > > > > I have a query that displays data that I would like to group by >week. I > > don't even really care how the week is defined as long as it is >constant. ie, > > sun- sat, mon - sun. > > > > I am not really that familiar with the date functions and did not >see one > > that seemed to help. > > > > thanks. > > > > marc > > _________________________________________________________________ Search & browse smarter, faster - download MSN Search Toolbar today, it's FREE! http://toolbar.msn.co.za?DI=1054&XAPID=2083 ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
