Calcutations in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two feilds in a table A & B, which I want to calulate (A * B = C) and
record the answer in feild C. In my form I have it calculating but it's not
recording the data in the table.
 
Amanda said:
I have two feilds in a table A & B, which I want to calulate (A * B = C) and
record the answer in feild C. In my form I have it calculating but it's not
recording the data in the table.

And it doesn't need to be nor should it be. Easily derived calculation results
should never be stored (you don't store them in Excel, why store them in
Access?).

Create a query based on your table (from which you have removed field C) and add
the calculation for C to the query. Now simply use the query in all places
where you would otherwise have used the table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top