How do you join 2 fields in a table

[Guest]

I have a table with 2 fields which I would like to combine for a new table.
One field is "ST_NAME" and the other field is "ST_SUFFIX". I have been able
to join the fields by using the following: NewStreet: [ST_NAME] & [ST_SUFFIX]
.. This works however I would like for their to be a space seperating the two
fields. For example I am now getting MAPLEDRIVE. I would like for it to be
MAPLE DRIVE. How do I get it to insert the space?

 

[Guest]

[ST_NAME] & " " & [ST_SUFFIX]

 

[Guest]

Thank You. That's just what I needed.

[ST_NAME] & " " & [ST_SUFFIX]

I have a table with 2 fields which I would like to combine for a new table.
One field is "ST_NAME" and the other field is "ST_SUFFIX". I have been able
to join the fields by using the following: NewStreet: [ST_NAME] & [ST_SUFFIX]
. This works however I would like for their to be a space seperating the two
fields. For example I am now getting MAPLEDRIVE. I would like for it to be
MAPLE DRIVE. How do I get it to insert the space?

 

[Joseph Meehan]

I have a table with 2 fields which I would like to combine for a new table.
One field is "ST_NAME" and the other field is "ST_SUFFIX". I have been
able
to join the fields by using the following: NewStreet: [ST_NAME] &
[ST_SUFFIX]
. This works however I would like for their to be a space seperating the
two
fields. For example I am now getting MAPLEDRIVE. I would like for it to be
MAPLE DRIVE. How do I get it to insert the space?

Are you really sure you want to do that?

You are storing the same data twice. Why? Don't store it just
recreated it as needed. Use a query if you like. Access would normally
rather re-create the combined information that to have it stored twice.

 

[Guest]

Hi MValentine,
Try this

[ST_NAME] &" " & [ST_SUFFIX]

Thanks
Maran