Calculations in Tables and Forms

[clairdorsey]

I need to add 10 fields together ....when using calculations in the table design view, I can get about 4 fields to calculate, any more than that I get errors.



I have also tried to do this in a form using text box calculations and still get errors

any ideas?

[ssanfu]

Welcome to the forum...

I do not use calculated fields in tables. IMO, a very bad idea.

Use a query to add the fields together.


Having said that, it sounds like you might not have a normalized structure....... not enough info to really determine. But adding 10 fields...???

[orange]

Can you give us a little more detail on WHAT you are trying to accomplish?

Adding 10 fields doesn't really tell us much.

Perhaps a description of your business issue/opportunity, your database tables and relationships....

You know --- I work for the ABC company. We deal retail sales, selling Products to Customers...
My issue is related to inventory -- we don't record Quantity of products sold daily, and often run out.
We need help.....

And welcome to the forum.

[clairdorsey]

Ok ... So a little more background

I work for a large University and am in a self supporting continuing education unit.

This access db is for financial management.

Need to show the difference between income codes and expense codes.
The data I need to add is separated into account codes ( like salary, benefits, office supplies)

I tried to add two expense codes in a query and field is blank...

[June7]

Arithmetic with Null results in Null. If either field is Null then the result will be Null. Handle Null with Nz() or Is Null.

http://allenbrowne.com/casu-12.html

http://allenbrowne.com/QueryPerfIssue.html#Nz

[orange]

clair,

I don't have a financial background, but I think this link may help with concepts of account definition/recognition.

Also here is a free data model from Barry Williams that may help with the tables and relationships. This model is generic and has the tables and relationships typically found in an accounting system. Your requirements may be different --you can use or remove elements/details that are not relevant to you.

good luck.

[clairdorsey]

Thanks to every one ... I'm making progress