IIf Statement, contains text?

[kennethnaga]

I have a new field in my query that I'm trying to develop a statement for. Essentially, there are two fields (from a table) containing a chemical test method. Most cases are instances of one field containing a value while the other does not (null). How do I return the value in the new field? I'm very new to Access/queries/VBA/SQL and any help will be appreciated!



Example:

Method 1	Method 2	New Field
D5453		D5453
	D7041	D7041

[pbaldy]

Try

Nz(Method1, Method2)

[kennethnaga]

Hi pbaldy, I don't really quite understand

[pbaldy]

Put that in a new field in your query, fixing the field names as appropriate.

[kennethnaga]

Works great, thank you!

[pbaldy]

Happy to help!