Michael
Give us a little more info.
1. Is this run for a "from start to finish" -ie, all data in the table
basis - or for a set period of time (12 weeks, with a starting date) or
user entered start - end dates?]
2. Is the desired output like this?
Week Of Total
10/28/02 $100
11/04/02 $300
11/11/02 $250
etc.
or this:
10/28/02 11/04/02 11/11/02 11/18/02
$100 $300 $250 $275
3. Is this another column involved in the grouping, say company, department,
etc.?
David Blocker
----- Original Message -----
From: "Michael Moser" <[EMAIL PROTECTED]>
To: "R:Base List Server" <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 12:27 AM
Subject: Totals by week
> Hi all,
>
> Some time back I think I saw a simple method for generating report totals
by week in a R:Base report but I can not seem to remember how it was done or
locate it - possibly a simptom of working too late into the evening ...
>
> Does anyone have a favorite solution to this problem. Basically I have
dated records that include numeric columns. There are not records for every
date. I need to print a report that generates a break footer with subtotals
at weekly intervals ending with each Sunday, but there are no records for
Sundays. All of the solutions I have come up with (using modular arithmetic
MOD 7 or 7 day increments using ADDDAY) seem a bit convoluted - or at least
my approach seems to be.
>
> I almost hate to ask because I am sure there is a really slick way to do
this, and I'm going to kick myself when I see it :-{
>
> Thanks,
> Michael Moser
>
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
> ================================================
> TO SEARCH ARCHIVES:
> http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
