Getting the structure right from the start

[John Pierce]

I want to be able to compare plan vs actual for this year and years past in a
sales database. Should all of this be in one table or should I put each year
in a separate table. If I put each year is a separate table how do I then
compare result by month for plan vs actual year or year?

 

[John Vinson]

I want to be able to compare plan vs actual for this year and years past in a
sales database. Should all of this be in one table or should I put each year
in a separate table. If I put each year is a separate table how do I then
compare result by month for plan vs actual year or year?

Certainly in one table - or perhaps two, one for plan and one for
actual. Storing data in tablenames (or fieldnames) is a Very Bad Idea.
Just have a Date/Time field containing the sale date; you can use
Queries to filter, sum, group by, etc. the year, or month or quarter
or week, as needed.


John W. Vinson[MVP]