Simple Multiplication

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I'm trying to multiply two fields from a single table
together in a query, and create a new column for this
value.
I don't know where to enter this expression. I'm getting
requests for paramaters... I'm lost.
I've tried using the wizard and help functions.
Let's assume I know nothing about Access. Can you give me
the EXACT steps I need to take to make this happen?

Thank you.
 
In query builder, click in a new column. In the "Field:" field, enter the
following:

NewValue: [NameOfField1] * [NameOfField2]


Change "NewValue" to be whatever you want to name the result. You could use
that name in reports or forms based on this query.


Rick



I'm trying to multiply two fields from a single table
together in a query, and create a new column for this
value.
I don't know where to enter this expression. I'm getting
requests for paramaters... I'm lost.
I've tried using the wizard and help functions.
Let's assume I know nothing about Access. Can you give me
the EXACT steps I need to take to make this happen?

Thank you.
 
When you create a query, you typically select table
columns to include in the query. They show up in the grid
at the bottom of the query. To create a new field (your
calculated one), go to the next available grid and type a
field name, followed by the calculation.
Example:
CalcFld:[myfirstfld] * [mysecondfld]

Hope this helps
 
Keith,

It's true you can use an expression of the form

CalcFld:[myfirstfld] * [mysecondfld]

to create a calculated field in the query. However, if the fields in the
expression above exist in more than one of the component tables in the
query, then Access has no way of know which of the fields the expression is
referring to. If that's the case, you can remove the ambiguity by
specifying which table the field belongs to, by writing:

CalcFld: [tableA!myfirstfld] * [tableB!mysecondfld]

hth
Paul
 
Back
Top