Percentage function in Form

[glen]

Hello,
I have field1 (RequestedQty) and field2 (DeliveredQty) and in field3 I have status of completion in percent.
I put the expression in field3 =[field1]/[field2]
It is working but if the delivered quantity is zero then it showing error #div/0!. which is not looking good.
So what expression we use in access for percentage.

Secondly I want to restrict (Deliverdqty) according to (Requestedqty).


Suppose we have 100 items in (Requestedqty). And if we want to enter 101 items in (Deliveredqty). It should not allowed.

[burrina]

=Nz([RequestedQty]/[DeliveredQty],0) 'Place this is Field 3 control source if it is unbound or else as Default Value

That should fix the problem.
If [Deliveredqty] > [Requestedqty] Then
MsgBox "Access is Denied,You are Delivering More Than You Are Requesting"
Me.Undo
Exit Sub
End If

Place on the OnCurrentEvent of the form.Hope this helps.

[glen]

Thanks.
It working fine.
Problem Solved.