tables based on dates

[Guest]

I am trying to develop a database that will allow me to shedule work based on
a 28 day cycle. So that each customer will have a reducing balance as each
28 days count down. Can anyone suggest hoe to do this in access?

Thanks

Jim

 

[John Vinson]

I am trying to develop a database that will allow me to shedule work based on
a 28 day cycle. So that each customer will have a reducing balance as each
28 days count down. Can anyone suggest hoe to do this in access?

Thanks

Jim

Insufficient info to help very much (reducing balance of WHAT?) but
you may want a simple two column table with fields for the CycleNumber
and 28 dates (perhaps omitting weekends and holidays if you don't
schedule work then). This could be joined to a WorkDone table with a
customerID, a date field, and other information as needed; join by the
date to pick up the CycleNumber and do a Totals query to count how
much work has been done that cycle.

John W. Vinson[MVP]