Hello,
I have about 60 fields that either will contain a number 1 through 4, or they won't contain a number at all.
I'd like to be able to add up all of these fields to get a grand total of the numbers in them. Is this possible, I assume it is, could someone help me out on this (unless it's too time consuming, It's not that big of a deal to have, just would be nice if we did).
Data is stored in the main Links database
Columns are in the Links table (I assume, it's the same table where people would normally enter their link information)
Fields are named cardqty1 through cardqty55
Thanks for your time, it is greatly appreciated.
I have about 60 fields that either will contain a number 1 through 4, or they won't contain a number at all.
I'd like to be able to add up all of these fields to get a grand total of the numbers in them. Is this possible, I assume it is, could someone help me out on this (unless it's too time consuming, It's not that big of a deal to have, just would be nice if we did).
Data is stored in the main Links database
Columns are in the Links table (I assume, it's the same table where people would normally enter their link information)
Fields are named cardqty1 through cardqty55
Thanks for your time, it is greatly appreciated.