Calculating in Tables

[keiath]

I have in my Table a simple calculation Fields are 'Income1' 'Exp1' 'Bal1'

In the table under Bal1 it

[Income1]-[Exp1] and that give me a result

There are 8 such lines so there is Income2, Exp2 Bal2 and so on

This works fine

However when I create a form if the second set has no entry it doesn't calculate the the totals at the bottom, i have to add 0 to each field so it shows the total

Try using the Nz faction but you cant do this in the tables

Any ideas? or should i not have cal in the tables?



Thanks

[ItsMe]

Calculated fields in tables may have a benefit if you are accessing the DB over the internet.

[June7]

What do you mean you have '8 such lines'? If you have multiple similar name fields, this indicates a non-normalized structure and will probably cause problems.

No record should have both income and expense data so this is also not a normalized data structure, however, this one can probably be worked with easily enough.

[keiath]

What do you mean you have '8 such lines'? If you have multiple similar name fields, this indicates a non-normalized structure and will probably cause problems.

No record should have both income and expense data so this is also not a normalized data structure, however, this one can probably be worked with easily enough.

There are 8 fields of income, exp and bal

all named Inc1, Inc2, Inc3 up to 8 then 8 expenses, exp1, exp2, exp3 up to 8 and then the calculation field for each inc and exp

[June7]

My comments still apply.

[keiath]

Got what you were saying and changed the structure of the table and now works fine