The subject basically sums it up. I am trying to figure out how to take one field and add it to two other fields and then put the total in a third field, I need to do this within the same record in a table entry.
I can do it with a query but I am trying to do it in the table view so I can see data from a whole screen of records instead of one at a time.
It is a inventory DB, each inventory item needs to have purchase price, tax, shipping, and then a total of the three so I can see the total cost for the item. I know I can manually enter it but I would rather avoid the human error aspect and make it easier to manage.
Does anyone know of a way to do this? I tried writing some expressions in the Validation Rule area but I keep getting a error.
I tried
=[field1]+[field2]
SUM([field1]+[field2])
I'm not sure if I am just using the wrong expressions or just doing it the wrong way.
Thanks,