weekly report

Hi all,
can anybody suggest me how to generate sales data of a particular month
divided into four weeks.

I mean how to generate weekly report.

Villi
Fri Apr 06 10:07:19 CDT 2007

gibbs wrote:

> Hi all,
> can anybody suggest me how to generate sales data of a particular
> month divided into four weeks.
>
> I mean how to generate weekly report.

Just use between() and calculate the initial and final days of the weeks you
need to report.
For the report, you may group the sales data by week, using or not using
"Start each group in new page" based on the estimated quantity of data you
get for every week and the space they occupy on the report.
--
News Microsoft

Anders
Fri Apr 06 11:50:03 CDT 2007

SELECT WEEK(date,2,2) As wk, SUM(amount() As sum_ sales FROM SalesData GROUP
By 1
-Anders

"gibbs" <gibbs@discussions.microsoft.com> wrote in message
news:07DD2B2E-72EB-4CF7-8489-43DBBFF99E04@microsoft.com...
> Hi all,
> can anybody suggest me how to generate sales data of a particular month
> divided into four weeks.
>
> I mean how to generate weekly report.

Gene
Fri Apr 06 13:00:45 CDT 2007

gibbs <gibbs@discussions.microsoft.com> wrote:

>can anybody suggest me how to generate sales data of a particular month
>divided into four weeks.
>
>I mean how to generate weekly report.

Anders gave some good advice, but what about months with five
weeks?

The company that I work for bills as of the 15th and the end of
the month. That is not an even split in February, but it does not
matter to us.

The split might matter to you. In particular, can a week span
months? There may be accounting considerations here. Is the report
used by accounting or sales? If both, you may have conflict on the
split.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

gibbs
Sat Apr 07 00:46:00 CDT 2007

Thats what my problem is. How to recognize the 1st day of the week starts on
which date. I mean suppose i want to take the report for the month of
april07, but from monday to saturday. so how to recognize that monday falls
on which date so that i can generate the report.

"Gene Wirchenko" wrote:

> gibbs <gibbs@discussions.microsoft.com> wrote:
>
> >can anybody suggest me how to generate sales data of a particular month
> >divided into four weeks.
> >
> >I mean how to generate weekly report.
>
> Anders gave some good advice, but what about months with five
> weeks?
>
> The company that I work for bills as of the 15th and the end of
> the month. That is not an even split in February, but it does not
> matter to us.
>
> The split might matter to you. In particular, can a week span
> months? There may be accounting considerations here. Is the report
> used by accounting or sales? If both, you may have conflict on the
> split.
>
> Sincerely,
>
> Gene Wirchenko
>
> Computerese Irregular Verb Conjugation:
> I have preferences.
> You have biases.
> He/She has prejudices.
>

Anders
Sat Apr 07 02:53:43 CDT 2007

That setting is exactly I used in the parameters of the Week function;
Week(2,2) means that the week's ordinal numbering counts from the first week
with four days in the year and with Monday as the first days of the week. A
week in any systems is always seven days.
If you want to exclude sales made on Sundays you can add a WHERE clause to
the query: WHERE DOW(Date)<>0
See Help for WEEK( )

-Anders


"gibbs" <gibbs@discussions.microsoft.com> wrote in message
news:65EB4DF9-76EB-49C6-8635-460538B21C09@microsoft.com...
> Thats what my problem is. How to recognize the 1st day of the week starts
> on
> which date. I mean suppose i want to take the report for the month of
> april07, but from monday to saturday. so how to recognize that monday
> falls
> on which date so that i can generate the report.
>
> "Gene Wirchenko" wrote:
>
>> gibbs <gibbs@discussions.microsoft.com> wrote:
>>
>> >can anybody suggest me how to generate sales data of a particular month
>> >divided into four weeks.
>> >
>> >I mean how to generate weekly report.
>>
>> Anders gave some good advice, but what about months with five
>> weeks?
>>
>> The company that I work for bills as of the 15th and the end of
>> the month. That is not an even split in February, but it does not
>> matter to us.
>>
>> The split might matter to you. In particular, can a week span
>> months? There may be accounting considerations here. Is the report
>> used by accounting or sales? If both, you may have conflict on the
>> split.
>>
>> Sincerely,
>>
>> Gene Wirchenko
>>
>> Computerese Irregular Verb Conjugation:
>> I have preferences.
>> You have biases.
>> He/She has prejudices.
>>