I have a report requirements that will count how many emails received on a
specified period and brake into weeks.

e.g.

Parameter: 01/01/2003 to 31/01/2003 - January
Output should be:

                            JANUARY
        Week1       Week2    Week3    Week4    Total
Total    500        100        350    400      1,350

I have a field Received Date which I can used but how can group them by
weeks?

Any help would be greatly appreciated...


TIA,
George

Dear

Group on Date and Select Week in Group On

1.     in report Design Toolabr and Select click on Grouping and Sorting
2.   click on row containg date and then select week in  group on in group
properties

i hope it will help

Amjad
----- Original Message -----
From: "George Oro" <george@c...>
To: "Access" <access@p...>
Sent: Sunday, March 23, 2003 10:55 AM
Subject: [access] Weeks Number


> I have a report requirements that will count how many emails received on a
> specified period and brake into weeks.
>
> e.g.
>
> Parameter: 01/01/2003 to 31/01/2003 - January
> Output should be:
>
>                             JANUARY
>         Week1       Week2    Week3    Week4    Total
> Total    500        100        350    400      1,350
>
> I have a field Received Date which I can used but how can group them by
> weeks?
>
> Any help would be greatly appreciated...
>
>
> TIA,
> George
>
>
>
>

Thanks Amjad, but the things is, how the system will recognize that these dates are under week 1,2,3 or
4 automatically.

Cheers,
George

> -----Original Message-----
> From: Amjad Saeed [mailto:amjadsaeed@b...]
> Sent: Sunday, March 23, 2003 8:35 PM
> To: Access
> Subject: [access] Re: Weeks Number
> 
> 
> Dear
> 
> Group on Date and Select Week in Group On
> 
> 1.     in report Design Toolabr and Select click on Grouping and Sorting
> 2.   click on row containg date and then select week in  group on in group
> properties
> 
> i hope it will help
> 
> Amjad
> ----- Original Message -----
> From: "George Oro" <george@c...>
> To: "Access" <access@p...>
> Sent: Sunday, March 23, 2003 10:55 AM
> Subject: [access] Weeks Number
> 
> 
> > I have a report requirements that will count how many emails received on a
> > specified period and brake into weeks.
> >
> > e.g.
> >
> > Parameter: 01/01/2003 to 31/01/2003 - January
> > Output should be:
> >
> >                             JANUARY
> >         Week1       Week2    Week3    Week4    Total
> > Total    500        100        350    400      1,350
> >
> > I have a field Received Date which I can used but how can group them by
> > weeks?
> >
> > Any help would be greatly appreciated...
> >
> >
> > TIA,
> > George
> >
> >
> >
> >
> 
> 
>