Dear Frank:
I see that thecolumn headers are still off off.
I will use "spaces" rather than "tabs"
There are three columns:
* Date
* Time
* Amount
Thus:
DATETIMEAMOUNT
01/08/2001 6:21 pm 130
01/09/2001 10:46 pm 148
01/09/2001 6:08 pm 116
01/10/2001 11:07 pm 148
01/10/2001 6:18 pm 138
01/10/2001 1:11 pm 122
01/10/2001 7:31 am 135
01/11/2001 9:53 pm 141
01/11/2001 5:56 pm 167
01/11/2001 7:36 am 141
01/12/2001 6:55 pm 131
01/12/2001 8:02 am 156
01/13/2001 6:21 pm 111
01/13/2001 12:16 pm 138
01/13/2001 8:34 am 175
01/13/2001 1:50 am 189
01/14/2001 6:07 pm 109
01/14/2001 11:58 am 95
01/14/2001 11:51 am 149
01/14/2001 8:06 am 151
01/14/2001 12:06 am 144
01/15/2001 11:28 pm 143
01/15/2001 6:18 pm 103
01/15/2001 12:04 pm 90
01/15/2001 7:44 am 116
01/15/2001 2:33 am 160
01/16/2001 11:28 pm 156
01/16/2001 11:04 pm 126
01/16/2001 6:01 pm 156
01/16/2001 7:57 am 156
01/17/2001 10:18 pm 111
01/17/2001 6:13 pm 126
01/17/2001 1:11 pm 158
01/17/2001 8:01 am 142
I want to get the number of records over a rolling XX Days -- actually,
21 Days.
This gets the number of records per day:
SELECT ;
Gluctmp1.date AS DailyDate, ;
COUNT(Gluctmp1.amount) AS DayCount;
FROM Gluctmp1;
WHERE ;
Gluctmp1.category = "Glucos";
GROUP BY Gluctmp1.date ;
ORDER BY Gluctmp1.date
-- Charles --
Website: http://homepages.uc.edu/~enzerch/
<http://homepages.uc.edu/%7Eenzerch/>
*"Medicine is a science of uncertainty and an art of probability"
*William Osler, M.D.
***Stop **Spammers**and **Virus Propagation***
***Before **forwarding**, please **delete**the history of all email
address***
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
