I need to write a formula to multiply answers in two fields,

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

Guest

I need my table to automatically multiply two fields together for each
record. Any ideas how I can achieve this?
 
In Access, tables don't perform calculations. Tables store data. Queries,
forms, reports, data access pages, macros and VBA code perform calculations.

In a query, you would use an expression such as ...

MyProduct: [MyField1] * [MyField2]

.... where 'MyProduct' is whatever name you want to use for the calculated
column in the query, and 'MyField1' and 'MyField2' are the names of your two
fields.

In the Control Source property of a text box on a form or report you would
use a similar expression ...

= [MyField1] * [MyField2]
 
Tables simply hold data. They do not provide functions. Once
designed there should be no more human interaction with the tables.
Use forms and queries to massage the data in tables.

HTH
 
You must log in or register to reply here.

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

Similar Threads

access compare values and select higher of two 1
Total Field? 3
Multiple field calculations 3
calculating fields 2
multiply one text box on report by a value 10
How to multiply number of hours by number? 6
Need a formula to act as a value 1
calculating fields 3

Back
Top