How do i combine columns Access 2003? Laura 28.09.2006 14:39:02 I have a database that has the street number in one column and part of the street name in two other columns. How can I combine them?

RE: How do i combine columns Access 2003? KARL DEWEY 28.09.2006 16:15:02 Address1: [Street Number] & “ “ & [Street Name1] & IIF([Street Name2] Is Null, Null, & “ “ & [Street Name2]) "Laura" wrote: [Quoted Text] > I have a database that has the street number in one column and part of the > street name in two other columns. How can I combine them?

RE: How do i combine columns Access 2003? Laura 28.09.2006 16:50:01 Karl, Thanks for your response, but where do I do that? Write that equation. "KARL DEWEY" wrote: [Quoted Text] > Address1: [Street Number] & “ “ & [Street Name1] & IIF([Street Name2] Is > Null, Null, & “ “ & [Street Name2]) > > "Laura" wrote: > > > I have a database that has the street number in one column and part of the > > street name in two other columns. How can I combine them?

RE: How do i combine columns Access 2003? KARL DEWEY 28.09.2006 17:37:02 In your query design view add it to a blank column in the Field row. "Laura" wrote: [Quoted Text] > Karl, > Thanks for your response, but where do I do that? Write that equation. > > "KARL DEWEY" wrote: > > > Address1: [Street Number] & “ “ & [Street Name1] & IIF([Street Name2] Is > > Null, Null, & “ “ & [Street Name2]) > > > > "Laura" wrote: > > > > > I have a database that has the street number in one column and part of the > > > street name in two other columns. How can I combine them?