formula in query criteria

  • Thread starter Thread starter tstew
  • Start date Start date
T

tstew

Hello,

I thought this would be straightforward, but I'm coming up with errors that
I can't resolve yet.

I would like to filter based on a calculation using data from two fields. I
put this formula in the criteria box on the query:

[OpeningBid]/[EstimatedValue]<1

It says the formula is too complex. I'm guessing I just don't have the right
syntax.

The error message is: This expression is typed incorrectly, or it is too
complex to be evaluated. For example, a numeric expression may contain too
many complicated elements. Try simplifying the expression by assigning parts
of the expression to variables.

Any ideas?

Thanks,
Mark
 
I put this formula in the criteria box on the query:
You did not say what field you applied this criteria to but I expect it had
no relation to your action.

Try this --
Open query in deign view, scroll to right to empty block in the FIELD row
and type --
Expr1: [OpeningBid]/[EstimatedValue]
Then under that in the Criteria row enter <1
 
THANKS, Karl!

That's what I ended up discovering. Then I had to test for null values. The
syntax is a little different than Excel, but I got there. And, it was the way
you said.

Thanks again,
Mark

KARL DEWEY said:
You did not say what field you applied this criteria to but I expect it had
no relation to your action.

Try this --
Open query in deign view, scroll to right to empty block in the FIELD row
and type --
Expr1: [OpeningBid]/[EstimatedValue]
Then under that in the Criteria row enter <1

--
Build a little, test a little.


tstew said:
Hello,

I thought this would be straightforward, but I'm coming up with errors that
I can't resolve yet.

I would like to filter based on a calculation using data from two fields. I
put this formula in the criteria box on the query:

[OpeningBid]/[EstimatedValue]<1

It says the formula is too complex. I'm guessing I just don't have the right
syntax.

The error message is: This expression is typed incorrectly, or it is too
complex to be evaluated. For example, a numeric expression may contain too
many complicated elements. Try simplifying the expression by assigning parts
of the expression to variables.

Any ideas?

Thanks,
Mark
Click to expand...
Click to expand...
 
Back
Top