What to do if a field is not found?

[Guest]

i trying to calculate sum of two different field and the validation rule
looks like these Sum([quantity]*[Unit price]) and it wrote SQL cannot find
quantity field. please help me hw to do it

 

[EeOr]

What exactly are you trying to do? If you want a calculated field on a form
then you would put your formula into an unbound text box under the data tab
and control source. you will not need to enter anything under the
valkidation. you may also want to use the NZ function in case any of your 2
fields are left blank. Try NZ(Sum([quantity]*[Unit Price])) - untested.

Jon

 

[John W. Vinson]

i trying to calculate sum of two different field and the validation rule
looks like these Sum([quantity]*[Unit price]) and it wrote SQL cannot find
quantity field. please help me hw to do it

Is the field *not found* - i.e. there is no field of that name in your table?

If so, correct the query to use fields which exist. You can't make bricks
without clay!

Or is the field there in the table but is NULL? If so, use the NZ() function
to convert the Null to Zero:

Sum(NZ([quantity]) * NZ([Unit price]))


John W. Vinson [MVP]