How to make a field which has the SUM of other fields ?

[Schorsch]

Hi,

in my form I have 2 fields, minor errors and major errors, now I wanna make a field "entire errors", which consists of the sum of minor and major errors. How can I do this ?

P.S.: each error field bases on it's own table.

Thanks,
Schorsch

 

[Adrianna]

Each error field is based on it's own table? So are you just counting the total number of records in all of the fields?

I guess I don't understand the logic behind it.

 

[Schorsch]

edit: the errors are stored in one table

 

[Schorsch]

did u read my edit ?

 

[Pat Hartman]

Place the following into the controlsource of the control that you want to display the total.
=MajorErrors + MinorErrors

If either field could contain a null value, you'll need to allow for that:
=Nz(MajorErrors,0) + Nz(MinorErrors,0)

 

[Schorsch]

it doesn't work, it shows me unbound, and when I open the form nothing is in the Enire_Errors field.

What's wrong ?

 

[Pat Hartman]

Did you use your own field names or the samples that I chose? Did you prefix the expression with the equal (=) sign?

 

[Schorsch]

yes I did.

 

[Pat Hartman]

You could post your code or we could continue to play guessing games.

 

[Schorsch]

=Nz(IN,0) + Nz(ME,0)

 

[Schorsch]

any advices ?

thanks

Schorsch

 

[Rich]

Do In and Me contain text or numeric values? They should also be enclosed by the way

 

[Schorsch]

they contain only numbers.

what can I do ?

cu
Schorsch

 

[Pat Hartman]

IN and ME are both reserved words and therefore should not be used to name your user defined objects. Try the effect of surrounding the names with square brackets.

=Nz([IN],0) + Nz([ME],0)

Also, make sure that the name of the control is something other than [IN] or [ME].

 

[Schorsch]

works now thank you very much!!!