defult value

  • Thread starter Thread starter laveshhp via AccessMonster.com
  • Start date Start date
L

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
 
Consider using the NZ() function or an IIf function.

=Nz(your current equation)

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

Seth
 
Back
Top