sum of multiple fields for a record

[mainerain]

How can I mathematically add different fields of one record together? Can this be done in Query Design?



Thanks

[mike60smart]

Hi

Yes you can.

You would create a Query based on the specific table.

Then in a blank new Column you would create the following Alias.

Total:Nz([Field1],0)+Nz([Field2],0)+Nz([Field3],0)

I am assuming that all three fields are numeric?

[mainerain]

Ok, Thanks for reply.
That makes sense.