In a function in a query or a calculated field how to I get Access to treat the null or no entry as a zero?
see this NZ()
AccessFunctions_SyntaxAndExamples TechontheNet M$oftVBA Function Details Debugging VBA and Error Handling Links to articles re Database Planning and Design DataPig Videos Revived DataPig Queries DataPig Form Basics
Forum Rules