469,908 Members | 2,213 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,908 developers. It's quick & easy.

Ms access

I used this format
=Sum(nz(VAL([Forms]![subCalendar]!
[Text1])))+(nz(VAL([Forms]!
[subCalendar]![Text25]))) , but I still keep getting #Name? in my
textbox.
1 Week Ago #1
1 3879
cactusdata
188 Expert 128KB
Val cannot neither accept nor return Null, so use:

Expand|Select|Wrap|Line Numbers
  1. =Sum(Val(Nz([Forms]![subCalendar]![Text1])))+Val(Nz([Forms]![subCalendar]![Text25]))
Also, do rename your textboxes to something meaningful.
4 Days Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

63 posts views Thread by Jerome | last post: by
49 posts views Thread by Yannick Turgeon | last post: by
64 posts views Thread by John | last post: by
17 posts views Thread by Mell via AccessMonster.com | last post: by
37 posts views Thread by jasmith | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.