New to access...is this possible?

[theta]

Hi

I am trying to move my excel worksheets onto access as the process has grown somewhat.

I normally have a data sheet containing financial data. I then have an analysis sheet that contains customer numbers, expected target, and then a SUMPRODUCT to the data sheet to summarise the amounts (also used a pivot table to speed things up)

I anticipate it will look like this in access

CALC...CUST1...CUST2...CUST3...COMMITMENT...TOTAL....DIFF..
1......ABC12...HIJ56...JKL78...100,000......90,000...10,000

The 90,000 would be the SUM of TOTAL from the DATA sheet, using CUST 1 + 2 + 3 as the criteria for CUSTOMER. The DIFF column would be a calculated column

Would this be the bet approach for this type of database

Then I can keep all of my data in one place, then define calculation in a seperate database. Several calculations, all different combination of CUST

 

[boblarson]

Your anticipation of the table structure needs some revision. You need to stop thinking in spreadsheet mode and start to think in Relational Database Mode. You do not use repeating fields in your database. So, NO Cust1, Cust2, Cust3, etc. You need to have ROWS for the customers and there is a lot more to it than you think.

So, I think we need to define what it is you are really looking to do with a database, and then design it properly. Doing it as a spreadsheet in Access will only lead to frustration and irritation as you constantly "band-aid" things to get the data out for reporting purposes.