How can I mathematically add different fields of one record together? Can this be done in Query Design?
Thanks
How can I mathematically add different fields of one record together? Can this be done in Query Design?
Thanks
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?
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
Ok, Thanks for reply.
That makes sense.