How to have a currency value read as a number?

[roxmyster]

I am trying to divide two fields, a currency with another numeric field, but access is giving me an error and I believe is due to the $ sign. How can I solve this issue. Thank you in advance

[Bob Fitz]

Show us the expression you are tying to use.
What is the reported error.
Where are you trying to do this.
Can you give us an example of the math.

[roxmyster]

Thank you for you reply!

The error I am getting is subqueries can’t be used in the expression kg_profit: IIf[chargeable weight] =0,0, [profit]/[chargeable weight].

Before I had just kg_profit: [profit]/ [chargeable weight] and neither way works. It gives me the same error

[kd2017]

Did you forget the parentheses in your code?

kg_profit: IIf([chargeable weight] =0,0, [profit]/[chargeable weight])

[Bob Fitz]

Thank you for you reply!

The error I am getting is subqueries can’t be used in the expression kg_profit: IIf[chargeable weight] =0,0, [profit]/[chargeable weight].

Before I had just kg_profit: [profit]/ [chargeable weight] and neither way works. It gives me the same error

Can you post a copy of the db with just a couple of dummy records to show the problem