Multiplication during query

[Guest]

Hello.

I am wondering what I am doing wrong here. I have a Currency field that I
am trying to muliply by .072 in another field, same table. and a third field
that needs to multiply that total by a Quantity field in another table.

I attempted putting this in the query under Criteria for the first
calculated Price:
=[myField]*.072
=[myTable]![myField]*.072

And a few other ways. Parenthesis and all, and nothing seems to work. When
I run the query for the report it shows !Error if im lucky.

I went to the Table view and tried to add it there, as it dosent really
matter if its calculated at reporting time through the query or right on the
table itself, but nothing seems to work.

What am I doing wrong?? Please and Thank you!

 

[Joseph Meehan]

Hello.

I am wondering what I am doing wrong here. I have a Currency field
that I am trying to muliply by .072 in another field, same table.
and a third field that needs to multiply that total by a Quantity
field in another table.

I attempted putting this in the query under Criteria for the first
calculated Price:
=[myField]*.072
=[myTable]![myField]*.072

FirstCalculation: [myField]*.072
SecondCalculation: [myTable]![myField]*.072

And a few other ways. Parenthesis and all, and nothing seems to work.
When I run the query for the report it shows !Error if im lucky.

I went to the Table view and tried to add it there, as it dosent
really matter if its calculated at reporting time through the query
or right on the table itself, but nothing seems to work.

You can't do calculations in a table. It only stores data. Use a
query, form or report.

 

[Guest]

I figured it out. The calculation actually needs to be

NameOfField: [FieldInQuery] * .072

NameOfField being totally what you want to name it...which is what I didnt
understand off the bat.

=)