choose a column

[Daytona Steve]

I am very new to this. I have a data base (Access 2002) with three text
columns, call them one, two, and three. "Three" should be the results
column.

I'd like "three" to be either the text value entered in column one or the
text value from column two. I'll take the risk that someone wont enter a
value in both columns for the same record.

Based on my reading its seems like a look up but I can't find an expression
that says "If one, one; if two, two.

As always I appreicate any help.

 

[Daytona Steve]

Thanks to both answers however, I have no idea where to enter these,
regardless of which in is correct. I'm a web designer, never used a database
but need to have the results "three" show up in table on a web site, one an
dtwo do not display. I have no problem getting the results to the site, I
just don't have any results to display.

I did search on intermediate if and got pages of expressions. Sorry to be a
complete idiot on this, but......

 

[Duane Hookom]

If this is to display on a web site, why not just use whatever language to do
this?

<%
If rs("One") > "" Then
Response.Write(rs("One"))
Else
Response.Write(rs("Two"))
End If
%>

I'm not sure if either Nz() or IIf() is supported when querying an Access db
from a web page.