M
Mike Cook
Guest
I have a table, in the table there are fields that have numbers of vents needed for a particular house. (e.g. vent type 1, vent type 2, vent type 3, etc. about 40 different types) The fields are numeric and the field name is a description of the vent. Now I want to add another field that totals all these fields so I know how many vents are on a house. What is the formula. I have tried "=[vent1] + [vent2] + [vent3]" . But when one of those fields has nothing in it, the answere field is blank. Oh by the way, I am new at access, but fluent on Lotus Approach.