I have more than one record in a table, but for the purpose of this question I have 3 records by way of example.
Record ID Value 1 Value 2 Value 3
Record 1 N/A 9430572.14
Record 2 N/A 100 0
Record 3 9406396.79 N/A 8528578.56
All value fields have been set to "text" and each value can be either NULL, "N/A", Number (but looks like text)
What I need to do is aggregate all of these together to form one value (there are actually 8 fields to aggregate). I can simply use Cdbl as it doesn't work for N/A or NULL, I can't use Sum....herein lies my problem.
I am wondering if there is an easy way to do this without using lots of Iif's, or do I really need to write a UDF, if I need a UDF, what would be quick?