2 columns into one

[Guest]

Hi!
I have a table with two columns of amounts, and I want to create query with
a new column where those are summarized.
One of the columns (C1) is more "trustworthy" than the other, so I want the
new column to show the value from C1 if there is one, and if not, the value
from C2. for each row.

Example
C1 C2 Result
55 64 55
477 477
664 664
224 224

8839 8839

 

[Allen Browne]

In the Field row of your query, enter:
Result: Nz([C1], [C2])

It's probably better to work with this just like that as a calculated
column, rather than storing a Result column, and populating it with an
Update query.