How do i combine columns Access 2003?

[Guest]

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?

 

[Guest]

Address1: [Street Number] & “ “ & [Street Name1] & IIF([Street Name2] Is
Null, Null, & “ “ & [Street Name2])

 

[Guest]

Karl,
Thanks for your response, but where do I do that? Write that equation.

Address1: [Street Number] & “ “ & [Street Name1] & IIF([Street Name2] Is
Null, Null, & “ “ & [Street Name2])

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?

 

[Guest]

In your query design view add it to a blank column in the Field row.

Karl,
Thanks for your response, but where do I do that? Write that equation.

Address1: [Street Number] & “ “ & [Street Name1] & IIF([Street Name2] Is
Null, Null, & “ “ & [Street Name2])

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?

 

[Guest]

Karl,
Thanks for your response. I have one follow up comment. If my field names
that I want to merge are Number, Road and Road 2 and I want to dump them into
a column called Address, how should I write my expression? I need to get my
head wrapped around this being as it's my first time. Thanks for your help
in advance.

Laura

In your query design view add it to a blank column in the Field row.

Karl,
Thanks for your response, but where do I do that? Write that equation.

Address1: [Street Number] & “ “ & [Street Name1] & IIF([Street Name2] Is
Null, Null, & “ “ & [Street Name2])

:

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?

 

[Guest]

If you may have cases where Road2 will be null the use this.
Address: [Number] & " " & IIF([Road2] Is Null, [Road], [Road] & " " & [Road
2])

If you will always have a Road2 data then use this.
Address: [Number] & " " & [Road], [Road] & " " & [Road 2]

Karl,
Thanks for your response. I have one follow up comment. If my field names
that I want to merge are Number, Road and Road 2 and I want to dump them into
a column called Address, how should I write my expression? I need to get my
head wrapped around this being as it's my first time. Thanks for your help
in advance.

Laura

In your query design view add it to a blank column in the Field row.

Karl,
Thanks for your response, but where do I do that? Write that equation.

:

Address1: [Street Number] & “ “ & [Street Name1] & IIF([Street Name2] Is
Null, Null, & “ “ & [Street Name2])

:

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?

 

[Guest]

Karl,
I'm getting a error message that reads, you may have omitted an invalide
comma or quotation marks.

If you may have cases where Road2 will be null the use this.
Address: [Number] & " " & IIF([Road2] Is Null, [Road], [Road] & " " & [Road
2])

If you will always have a Road2 data then use this.
Address: [Number] & " " & [Road], [Road] & " " & [Road 2]

Karl,
Thanks for your response. I have one follow up comment. If my field names
that I want to merge are Number, Road and Road 2 and I want to dump them into
a column called Address, how should I write my expression? I need to get my
head wrapped around this being as it's my first time. Thanks for your help
in advance.

Laura

In your query design view add it to a blank column in the Field row.

:

Karl,
Thanks for your response, but where do I do that? Write that equation.

:

Address1: [Street Number] & “ “ & [Street Name1] & IIF([Street Name2] Is
Null, Null, & “ “ & [Street Name2])

:

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?

 

[Guest]

Which of the two did you use?

I think you mis-stated the error message because if it was invalid and
omitted it would not cause an error.

Karl,
I'm getting a error message that reads, you may have omitted an invalide
comma or quotation marks.

If you may have cases where Road2 will be null the use this.
Address: [Number] & " " & IIF([Road2] Is Null, [Road], [Road] & " " & [Road
2])

If you will always have a Road2 data then use this.
Address: [Number] & " " & [Road], [Road] & " " & [Road 2]

Karl,
Thanks for your response. I have one follow up comment. If my field names
that I want to merge are Number, Road and Road 2 and I want to dump them into
a column called Address, how should I write my expression? I need to get my
head wrapped around this being as it's my first time. Thanks for your help
in advance.

Laura


:

In your query design view add it to a blank column in the Field row.

:

Karl,
Thanks for your response, but where do I do that? Write that equation.

:

Address1: [Street Number] & “ “ & [Street Name1] & IIF([Street Name2] Is
Null, Null, & “ “ & [Street Name2])

:

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?

 

[Guest]

I copied the second one.

Which of the two did you use?

I think you mis-stated the error message because if it was invalid and
omitted it would not cause an error.

Karl,
I'm getting a error message that reads, you may have omitted an invalide
comma or quotation marks.

If you may have cases where Road2 will be null the use this.
Address: [Number] & " " & IIF([Road2] Is Null, [Road], [Road] & " " & [Road
2])

If you will always have a Road2 data then use this.
Address: [Number] & " " & [Road], [Road] & " " & [Road 2]

:

Karl,
Thanks for your response. I have one follow up comment. If my field names
that I want to merge are Number, Road and Road 2 and I want to dump them into
a column called Address, how should I write my expression? I need to get my
head wrapped around this being as it's my first time. Thanks for your help
in advance.

Laura


:

In your query design view add it to a blank column in the Field row.

:

Karl,
Thanks for your response, but where do I do that? Write that equation.

:

Address1: [Street Number] & “ “ & [Street Name1] & IIF([Street Name2] Is
Null, Null, & “ “ & [Street Name2])

:

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?

 

[Douglas J. Steele]

The second one is, in fact, invalid.

Try:

Address: [Number] & " " & [Road] & " " & [Road 2]


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I copied the second one.

Which of the two did you use?

I think you mis-stated the error message because if it was invalid and
omitted it would not cause an error.

Karl,
I'm getting a error message that reads, you may have omitted an
invalide
comma or quotation marks.

:

If you may have cases where Road2 will be null the use this.
Address: [Number] & " " & IIF([Road2] Is Null, [Road], [Road] & " " &
[Road
2])

If you will always have a Road2 data then use this.
Address: [Number] & " " & [Road], [Road] & " " & [Road 2]

:

Karl,
Thanks for your response. I have one follow up comment. If my
field names
that I want to merge are Number, Road and Road 2 and I want to dump
them into
a column called Address, how should I write my expression? I need
to get my
head wrapped around this being as it's my first time. Thanks for
your help
in advance.

Laura


:

In your query design view add it to a blank column in the Field
row.

:

Karl,
Thanks for your response, but where do I do that? Write that
equation.

:

Address1: [Street Number] & " " & [Street Name1] &
IIF([Street Name2] Is
Null, Null, & " " & [Street Name2])

:

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?