M
Mary M
We have a DB that is holding info for different people in several different
fields, some of which are not populated. An example would be:
LastName FirstName Field1 Field2 Field3 Field4
Test1 Test1 1 3
Test2 Test2 2 3
Test3 Test3 1 2 4
How can I run a query that would return only the fields with values per
person? An example of the desired result would be:
Test1 Test1 1 3
Test2 Test2 2 3
Test3 Test3 1 2 4
Many thanks in advance for any assistance.
fields, some of which are not populated. An example would be:
LastName FirstName Field1 Field2 Field3 Field4
Test1 Test1 1 3
Test2 Test2 2 3
Test3 Test3 1 2 4
How can I run a query that would return only the fields with values per
person? An example of the desired result would be:
Test1 Test1 1 3
Test2 Test2 2 3
Test3 Test3 1 2 4
Many thanks in advance for any assistance.