formula in query criteria

[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

 

[KARL DEWEY]

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

 

[tstew]

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

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.

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