Dsum??

[jesseb]

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]

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]

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.