newbie question access 2007 query

[accs]

sorry for asking this foolish question.

can i calculate 3 fields


ex. total: [rate]*[dys] (working)
ex2. total: [rate]*[dys]-[late] (not working when one of the field(late) doesnt have value)what i want to happen is even if the late field doesnt have value i want it to still calculate

just like in excel =a1*b1-c1 (even if the c1 doesnt have value it still works properly

but in access total: [rate]*[dys]-[late] (if the late doesnt have value, nothing shows up in total field, even though rate and dys have.



what i did was i assigned the default value of late field properties to 0.

but the 0 is just so annoying to see when i have to many data.

can i calculate 3 fields in access just like excel even if one of the field doesnt have value?

if my only option is to set the default value of late to 0 , is it posibble to hide the default value?

thanks and really appreciate your help

 

[Uncle Gizmo]

Search the forum for the Nz function.

 

[Uncle Gizmo]

http://www.access-programmers.co.uk/forums/showthread.php?t=174642

 

[accs]

thanks for helping me, thanks for the link

really appreciate it

its now solve .