In Table can I sum the amount in field 1 & 2, & enter it in field 3

[grantyann]

Hi, I'm a newbie. I have three fields...Price, Tax and Total. In table view, is there a way that I can enter the sum of field 1 & 2, and have it automatically show up in field 3? Thanking you in advance.

grantyann

 

[EllieFantHome]

I have always been told that you don't store calculated fields in a table. You would create a query and have the query make the calculations for you. When you create a report and/or form, the calcualtions would appear on the report and/or form just as if they were stored in a table.

HTH