Total of unbound text fields

[Akchayan]

I have 5 unbound text fields, the user enters a money amount there. I want the total of these 5 fields to be in the "Total" field, but sometimes the user only uses only 2 of the 5 unbound text fields for example. I have tried it like this:

=[Summe1]+[Summe2]+[Summe3]+[Summe4]+[Summe5]

but it only works if all 5 fields have a value, so how can I solve this differently?

[CJ_London]

use the nz function

=nz([Summe1],0)+nz([Summe2],0)+......

[Akchayan]

use the nz function

=nz([Summe1],0)+nz([Summe2],0)+......

I did it like this:
=nz([Summe1],0)+nz([Summe2],0)+nz([Summe3],0)+nz([Summe4],0)+nz([Summe5],0)
but there is always an error:
The expression you entered is syntactically incorrect

[CJ_London]

don't see anything wrong with the syntax - You do have this in the controlsource of an unbound text box? And all the control names are correct?

[Akchayan]

Yes i do have the control names correct and i have it in the controlsource

If it helps this is the full error message:
You have not specified an operand or operator, you have entered an invalid pointer or comma, or you have entered text without enclosing it in inverted commas.

[Micron]

I want the total of these 5 fields to be in the "Total" field

If that means you want to store the total in a table field, then you should forget about solving this and should not store the total.

[CJ_London]

OK so you are saying you can't enter the formula, you get an error when you try to exit the controlsource.

So start with entering

=[Summe1]

in the control source then move to a different property. If that works then modify to
=nz([Summe1],0)

and if that works, add the next

=nz([Summe1],0)+[Summe2]

etc

[Akchayan]

If that means you want to store the total in a table field, then you should forget about solving this and should not store the total.

I don't want to save it in a table but I want it to be visible in the report.

[Akchayan]

OK so you are saying you can't enter the formula, you get an error when you try to exit the controlsource.

So start with entering

=[Summe1]

in the control source then move to a different property. If that works then modify to
=nz([Summe1],0)

and if that works, add the next

=nz([Summe1],0)+[Summe2]

etc

=[Summe1] this works.

=nz([Summe1],0) but this doesnt work

[Micron]

Any chance you can post a copy of your db? As long as all the field names are correct, what you've been trying should work.
Note - you would copy db, compact/repair the copy and zip. See how to attach files at top of forum window if you need it.

[Akchayan]

Any chance you can post a copy of your db? As long as all the field names are correct, what you've been trying should work.
Note - you would copy db, compact/repair the copy and zip. See how to attach files at top of forum window if you need it.

Database1.zip
This is an prototype of the DB.

[CJ_London]

works for me

[Akchayan]

works for me

What exactly did you put in the controlsource? Or could you please post your variation from the db?

[CJ_London]

I put as advised

=nz([Summe1],0)+nz([Summe2],0)+nz([Summe3],0)+nz([Summe4],0)+nz([Summe5],0)

just copy/paste the above

if the nz doesn't work for you, perhaps it is a language thing

[Micron]

Me too. I didn't worry about the nz yet though.



but nz works too