Getting the structure right from the start

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...

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]
 
Back
Top