Table Design Question...simple (I think)

I am trying to design a table(s) that will keep track of monthly sales. We receive sales information monthly and the field name every month is "clcsal"

How do I design a table that will keep track of every months sales for 3- 5 years? I need to do queries for different sets of months, since a lot of our incentives do not run in a calendar year and also vary in length. I am pretty sure that I have the rest of the database designed properly, but I want to do this table the most efficient way possible.

Thanks for any suggestions...

Jim Cuckovich Received on Thu Jan 04 2001 - 11:29:01 CST