469,906 Members | 2,215 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Undesired #Name? Result

I used your format and Rick's
Expand|Select|Wrap|Line Numbers
  1. =Sum(nz(VAL([Forms]![subCalendar]![Text1])))+(nz(VAL([Forms]!subCalendar]![Text25])))
but I still keep getting #Name? in my textbox.
1 Week Ago #1

✓ answered by isladogs

Hi & welcome to the forum

Whilst I'm sure your questions is clear to you, I'm sorry to say its less than clear to me.
For example, what does 'your format' mean? And who is Rick?

You will need to provide additional context so one of us can answer properly

The #Name error normally indicates that a field listed doesn't exist...or perhaps has been incorrectly spelt

2 3908
isladogs
315 Expert Mod 256MB
Hi & welcome to the forum

Whilst I'm sure your questions is clear to you, I'm sorry to say its less than clear to me.
For example, what does 'your format' mean? And who is Rick?

You will need to provide additional context so one of us can answer properly

The #Name error normally indicates that a field listed doesn't exist...or perhaps has been incorrectly spelt
1 Week Ago #2
NeoPa
32,231 Expert Mod 16PB
Hi & welcome to Bytes.com.

I agree with Isladogs about there being no context defined in or for your question, and thus it means almost nothing to anyone who doesn't already know what you're talking about (Rick maybe?).

Nevertheless, if we assume that you have two Controls on the same Form where you've got the (unnamed) TextBox with the formula - possibly in the Header Section, then you shouldn't need to specify the Form in your references. Perhaps you could try :
Expand|Select|Wrap|Line Numbers
  1. =Sum(Val(Nz([Text1],0)))+Sum(Val(Nz([Text25],0)))
Certainly, the Nz() call would need to be within the Val() one. Otherwise, if any value is Null then it will be fed to the Val() function and produce #Name?. Giving this to Nz() will not fix it in any way of course.

Let us know how you get on. Remember, we only know what you tell us so please tell us clearly.
1 Week Ago #3

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.