IIf statement

S

SeanE

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
 
D

David Cox

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

and the else case?
 
S

SeanE

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
 
N

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
 
D

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.
 
Top