No it's for interest rates.. wich are updated a week at a time.. they database is going to be used w/ VB so that employees can enter a specific date and pull the interest rates on that date.. but the rates change once a week and stay that way for an entire week.. so instead of entering 7 different dates each time the interest changes.. i am trying to set it up so that i can enter a range and have it add the rates for each day in that range.

phew...

I am pretty sure i can do this by previously entering every date into the table and just updating the interest rates for those dates each week.. but i would hate to have to go in and enter every day for the next 5 years, plus 3 years back.. unless there is an easy way to do that