consolidating fields 1

[cochise]

I have a query with two fields. Each row has 1 or both of the fields populated. If both are populated the value is the same. How can I create a 3rd field that consolidates the two, so that there are no null values?

 

[psemianonymous]

Do you mean permanently, or just make a query?

The most minimalist would be to make a query, pull in the two columns in question and put a third column in the query like so:

THIRD: Nz([EXACT_NAME_OF_FIELD_ONE],[EXACT_NAME_OF_FIELD_TWO])



That will do exactly what you need.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm