calculation before/after

[kabir_hussein]

Hi i have a report which has a textbox which shows outstanding orders using the following code

=[quantity ordered]-Sum([qty delivered]-[qty rejected])

however if there no qty delivered/qty rejected is there anyway i can have the textbox showing the quantity ordered value.

at present if there is no qty delivered/qty rejected the textbox is blank

many thanks in advance

 

[spacepro]

Use the IIf function, look it up in Access Help.

If you use the expression builder it will tell you which part of the IIF statement is true and false.

Regards

Andy