defult value

[laveshhp via AccessMonster.com]

Hello!
i create one form with subform ,subform have three field (e.g item # ,qty ,
Price) and i create subtotal field uder page footer now again i create one
field(subtotal subform) in main form which bring value from subform
(subtotal field value)
now problem is when i open form my main form field (subtotal subform) is
blank i need defult value 0.00

thanks

 

[Guest]

Consider using the NZ() function or an IIf function.

=Nz(your current equation)

=IIf(your current equation >0, your current equation, 0)

Seth