I have a database that is full of work orders, and I need to run a report that will list the truck and the repair total in the corect category (eg..Tire repairs in the tire column and lights in the light column).
The problem I am having is if the truck did not have any work done in a category it should be zero and should not affect the total. Now if a filed has no value my total field will not add all the values if one is empty unless I remove the blank field. How can I add the fields together even when one has no value. This is in Access 2000 and I am using a query for each category that totals that categorys repair for each truck.
Then I combine the querys to build the reports. I have manually checked the figures and they are correct but I cannot get the field to add if one is blank. all of the filed formats in the report are currency and changeing the format does not seem to make a difference.
Dennis
