IIf statement

[Guest]

Not to good on IIF statements, i need one to show

IFF qty received is greater than or = to qty ordered then show 0

i,ve tried but can not seem to get it to work

any help would be great
Thanks
Sean

 

[David Cox]

IFF qty received is greater than or = to qty ordered then show 0

and the else case?

 

[Guest]

Sorry david, or else i need to have the qty received "if anything is
received sometimes there 0 received" less the qty orderd to show a balance.
ie..
ordered 10 received 10 balance 0(because it's = to or greater than) else if
ordered 10 received 9 balance 1.
hope i,ve explained this ok
Thanks for your time
Sean

 

[Nick 'The database Guy']

Hi Sean,

For a start its IIf , not IFF, and the syntax is as follows
IIf(condition, true part, false part).

Hope this helps.

Good luck.

Nick

 

[David Cox]

Then Sean was right, it is not spelled IFF, but MAX :->

MAX ([Qty_ordered]-[Qty_received],0)

A tip that I learned from usenet recently.