I have a membership database of about 1000 records containing names, addresses, interests, monies paid for various activities, etc.
As annual renewals are processed, one or possibly two volunteers (who may have had experience with Excel only) will be upgrading the membership table via a renewal...
I have an Access table containing numeric fields Fld1, Fld2, Fld3, ... FldN.
In a select query containing these fields is a calculated field FldTotal:Fld1+Fld2+Fld3+...+FldN.
In the datasheet view the FldTotal will not calculate unless each field has a numeric value. A blank or empty field...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.