Home -> Usenet -> comp.databases.theory -> Table Design Question...simple (I think)

Table Design Question...simple (I think)

From: Jim <ppetty_at_part.com>
Date: Thu, 4 Jan 2001 12:29:01 -0500
Message-ID: <MPG.14be7cbeaeb32c2c989688_at_news.supernews.com> 






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 - 18:29:01 CET












Original text of this message