I have a database where we log # of pallets, pieces and weight of inbound parts. We manually enter the pallets, pieces, and weight. I need a weekly sum of all three as well as a monthly sum. No big deal except that our billing cycle does not follow any standard calendar or fiscal year. We are beginning next year on 12/29/03 and the month end will be 01/25/04. 01/26/04 - 02/20/04 is the next month, 02/21/04 - 03/26/04 is the next month...etc. I am trying to avoid exporting this to Excel and doing all of this manually. Ideally I would like to have two tables, one for monthly and one for weekly, with the sums as I need to create charts based on the tables. I have racked my brain and can't come up with a solution. I know it can't be as difficlut as I am making it.
Thanks in adcance for any help,
javierryan6