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 ?

 

[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 ?

 

[Schorsch]

yes I did.

 

[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

 

[Schorsch]

works now thank you very much!!!