What to do if a field is not found?

B

betwo

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
 
J

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
Click to expand...

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]
 
Top