Design Help Needed

[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?

 

[Duane Hookom]

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.