jesseb
01-09-2002, 01:46 PM
I am creating a database to track sales forecasting. I have one table that has Revenue. This table has fields for months. The fields are like this: SKU; Jan-02; Feb-02;... I would like to sum the all fields except SKU continually. So if I were to add another field it would be included in the sum. Any help is appreciated.
glynch
01-10-2002, 04:32 AM
I wouldn't create a table with a different field for each month. You could replace them with one date field and then do the summation in a query or queries that have each month as a criterion.
jesseb
01-10-2002, 08:06 AM
I would have liked to do that. However this database is built off importing a spreadsheet from Excel first. In the spreadsheet are number of units sold with months essentially as fields. The price also changes with months in relation to the Company and SKU.
Pat Hartman
01-11-2002, 11:27 AM
There really isn't any point to importing this data into Access unless you are willing to normalize it. Access is not a spreadsheet and therefore deals with rows and columns in a different manner. The strength of a relational database lies in it's ability relate data. By flattening the structure, you remove much of its capabilities.
Leave the data where it is and use pivot tables to do your reporting.