General discussion
March 6, 2002 at 05:24 AM
richard.safford

Access and Division Expression

by richard.safford . Updated 24 years, 5 months ago

I am having a problem with Dividing by zero errors within a Query. The database has to have default values of 0 because this database application needs to generate negitve number variances. I am currently getting a #Error message within the querry field. But any field with positive or negative numbers is generating the correct number.

The expression is
1 This is the definition:
(([Table_orQuery])![Table_name_1]/[Table_or_Query]![Table_Name_2]))

Can anyone please give me some insite.
Thanks

This discussion is locked

All Comments