nsaints
02-18-2002, 09:09 PM
I've built a simple database to assist me with invoicing jobs for customers. I need to total the values from four fields: Labour, Materials, Subcontract, Mileage and a "Total" field in order to raise an invoice. However not all jobs have values in all 4 fields.
How do I get the total box not to return an "error" if there are not values in all four fields.
Example: job for customer XX needs work comprising of labour, materials and mileage, but no subcontract. The answer I get in the total box is error, unless I add a figure to the empty field??
How do I get the total box not to return an "error" if there are not values in all four fields.
Example: job for customer XX needs work comprising of labour, materials and mileage, but no subcontract. The answer I get in the total box is error, unless I add a figure to the empty field??