Re: 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.

Why not simply do something like this:

   Sales (_year_: integer, _month_: varchar, clcsal: float)

Or am I missing the point?

Andi. Received on Fri Jan 05 2001 - 16:08:08 CET