2007 Access-Table add subtract fields

Question

I have 3 column, one is amount, second is paid, third is balance,

I'm trying to get third field to subtract the first two. ya know like in excel when its easy. I didn't think It would be this difficult. no I don't know anything about coding

Answer 1

I need a formula or code or expression or something that I can't figure out how to write, the expression builder isn't working or I don't know how to use it.

What Tom posted was an example of SQL 'code' of a query.  

In query Design View place your table in the space above the grid and click on the fields and drag to the field row of the grid.

Click on the VIEW icon and select SQL View.   At the end of the SELECT statement shown enter --

a comma and then       [amount]-[paid] as balance

Save the query.    Run the query.

Answer 2

As Karl said, as a general rule we don't store calculated values. Does your table only have those three columns? I would think it would need more.

What does your app do?

Answer 3

Access tables are not Excel spreadsheets.   Do the math in a query, form or report.

Answer 4

I understand its not excel. its completely different.

I need a formula or code or expression or something that I can't figure out how to write, the expression builder isn't working or I don't know how to use it. i've gotten really far in this ginormous project, but a few thing I cant write the code for.

Answer 5

Use a query; something like:

select amount, paid, amount-paid as balance

from yourTable