Design Help Needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to build a database to calculate and track employee bonuses
throughout the year. Bonus data is calculated weekly. My question is: How do
I track weekly information in the database? Is there a good way to use a
calendar object to automate the tracking of week1 through week 52?

Thanks for any insight?
 
I would not worry about the week number. Consider using a date which could
be the beginning of the week. Using a date allows you the flexibility to
calculate bonus data on a non-weekly basis in the future when managers
change their minds.
 
Back
Top