IIF Result Parameter Problem

[SteveE]

I have a query which uses several IIF statements in different fields the end field being a simple compare, if one value is greater than another+5% then no="OK" yes="Check"
This is the final IIF

Diff: IIf([InvVal]>[EstPrice]+[EstPrice]*0.05,"Check","OK")

I only want to show those records requiring the "Check" but if I use "Check" in my criteria I am asked for "EstPrice" or "BaseRate" as these are based on other IIf statements. I have tried using a form to feed the parameter but still the same result. I think I should be joining together the different IIFs but am finding this a difficult option so ...

Any sugestions please

Steve

 

[Brianwarnock]

If I understand you correctly you want to put "check" in the criteria of the Diff field and Estprice is a calculated field also, which inturn is based on another calculated field BaseRate, in which case these calculations must go into the criteria, it is probably simpler to run an additional query in which case "check" can be used in the criteria of Diff.

Brian

 

[SteveE]

Many thanks Brian, baseing my final query on the calculating query works great

Steve