How To Add a Space In Between

[davec69]

I have a query that pulls information from two different columns in a linked table, and places them together in a single column in a new table. The expression that i use in the query is: Expr1: [ARTINAME]+[ TITLE]. I need to put a space between the two. Is there a way to put a space in between these two when written to the new table?

 

[Uncle Gizmo]

Expr1: [ARTINAME]+[ TITLE]

Expr1: [ARTINAME] & " " &[ TITLE]

I think that will do it.

 

[davec69]

That worked, perfectly. Thanks for your help.

 

[davec69]

Just in case others attempt this. There was an error in my original expression posting. It should read:

Expr1: [ARTINAME] & " " &[TITLE]