J
jjpittman via AccessMonster.com
I have a table [tblFloor] 1100 different products [Product] with ship dates
[SDate] and cases shipped [Cases] for about a year; this table has about 760,
000 records. I need to have a running total for each of the products that
total shipments [Cases] for 5 days incrementing 1 day at a time. Then need
the max total for each particular product for the 5 day sub total.
[tblFloor]
[ID]
[Product]
[SDate]
[Cases]
[SDate] and cases shipped [Cases] for about a year; this table has about 760,
000 records. I need to have a running total for each of the products that
total shipments [Cases] for 5 days incrementing 1 day at a time. Then need
the max total for each particular product for the 5 day sub total.
[tblFloor]
[ID]
[Product]
[SDate]
[Cases]