Access query formula

[ariel20029]

Hi,
I have a simple formula in an access query that is returning -1 instead of 10000000. Can you take a look at the formula and let me know what I am doing wrong. Its basically supposed to return 10000000 if greater than 25000 or less than -25000
RESEARCH: IIf([Change Unit Price]>=25000,10000000,0) Or (IIf([Change Unit Price]<=-25000,10000000,0))


thanks so much for your help.
Sharon

 

[Norie]

Try this.

IIf([Change Unit Price]>=25000,10000000, IIf([Change Unit Price]<=-25000,10000000,0))

 

[ariel20029]

Try this.

IIf([Change Unit Price]>=25000,10000000, IIf([Change Unit Price]<=-25000,10000000,0))

Thank you so much, that worked.
Sharon

 

[ariel20029]

Thank you so much, that worked.
Sharon

I have one more formula that is not working can you help?
Not Renewed Yet: IIf(IsNull([Order Number]) And ([MaxOfEnd Date_PY]<=#6/30/2015#),10000,0)
thanks so much for your help.
Sharon

 

[Norie]

Try this.

Not Renewed Yet: IIf(IsNull([Order Number]) Or [MaxOfEnd Date_PY]<=#6/30/2015#,10000,0)

 

[ariel20029]

Try this.

Not Renewed Yet: IIf(IsNull([Order Number]) Or [MaxOfEnd Date_PY]<=#6/30/2015#,10000,0)

Sorry that did not work its continuing to return 10000 when order number is null. Any other suggestions. thanks for your help.
Sharon

 

[Norie]

Typo, the Or between the expressions should, of course, be And.

Not Renewed Yet: IIf(IsNull([Order Number]) And [MaxOfEnd Date_PY]<=#6/30/2015#,10000,0)