By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,045 Members | 1,305 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,045 IT Pros & Developers. It's quick & easy.

Update Query

P: 42
How do I use Update Query on my form to zero out the calculated formulas instead of showing error. I have at least 9 fields. One table and these fields are unbound. I'm a newbie so I need like an detailed instructions.

Thank you all.
John
Sep 18 '08 #1
Share this Question
Share on Google+
4 Replies


nico5038
Expert 2.5K+
P: 3,072
Calculated formula's aren't stored in a table as that's creating redundant data.
Redundant data in a table is bad design, as you'll need to change it when one of the used variables changes and what happens when you "forget" that...

Just use "unbound" fields for the formula's and when you want to show it just us the same formula in a query.

Getting the idea?

Nic;o)
Sep 18 '08 #2

P: 42
Thanks.
On the calculated formula on the form and on the Data Entry mode- How can you make it default to "0" instead of showing "Error"?
John


Calculated formula's aren't stored in a table as that's creating redundant data.
Redundant data in a table is bad design, as you'll need to change it when one of the used variables changes and what happens when you "forget" that...

Just use "unbound" fields for the formula's and when you want to show it just us the same formula in a query.

Getting the idea?

Nic;o)
Sep 22 '08 #3

nico5038
Expert 2.5K+
P: 3,072
In general Null values in fields (or typo's) cause this error.
When you want to be sure Null gives no #error, use the NZ() function like:

=NZ(field1)*NZ(Field2)

Nic;o)
Sep 22 '08 #4

P: 42
THANK YOU. That works!

In general Null values in fields (or typo's) cause this error.
When you want to be sure Null gives no #error, use the NZ() function like:

=NZ(field1)*NZ(Field2)

Nic;o)
Sep 22 '08 #5

Post your reply

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