E
EH
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!
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!