Too complex expression to be calculated

[Guest]

I am new to Access so this may be easy. I have a query with the following
expression, Remaining Containers: GetRemainingContainers([EAIID]) and I want
to multiply this column by a concentration column so here is what I did.
Expr1: [Remaining Containers: GetRemainingContainers]*[Concentration]. When I
try to view the query I get an error stating, this expression is incorrectly
typed, or it is too complex to be evaluated.

If anyone can give me any guidance I would greatly appreciate it. Thank you
in advance.

Angel

 

[John Spencer]

Try the following.

Expr1: GetRemainingContainers([EAIID])*[Concentration]

You have to redo the calculation; you cannot refer to the alias of your
calculated column.

 

[Duane Hookom]

Try
Expr1:GetRemainingContainers([EAIID]) * [Concentration]
Does the function explicitly return a numeric value?

 

[Guest]

Thanks both of you for the help and a fast response. It works now and yes I
should always receive a numeric value, the only places I have #ERROR are in
the rows where the concentration is blank. Thanks again, I know where to look
the next time a have a problem.

Try
Expr1:GetRemainingContainers([EAIID]) * [Concentration]
Does the function explicitly return a numeric value?

--
Duane Hookom
MS Access MVP
--

I am new to Access so this may be easy. I have a query with the following
expression, Remaining Containers: GetRemainingContainers([EAIID]) and I
want
to multiply this column by a concentration column so here is what I did.
Expr1: [Remaining Containers: GetRemainingContainers]*[Concentration].
When I
try to view the query I get an error stating, this expression is
incorrectly
typed, or it is too complex to be evaluated.

If anyone can give me any guidance I would greatly appreciate it. Thank
you
in advance.

Angel