Update Query

[John Torres]

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

[nico5038]

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)

[John Torres]

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)

[nico5038]

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)

[John Torres]

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)