ODBC query concatenation

[supmktg]

I'm creating a query against an ODBC data file in which a table containsa field for [FirstName] and another for [LastName]. I would like the result to show [FirstName] &" "& [LastName] instead of two seperate columns. When I enter a new column and build the Expr1: [FirstName] &" "& [LastName] , I get an enter parameter dialog box. I want the entire column filled down with [FirstName] &" "& [LastName] from each record. Is this possible in a query against an ODBC table?

Thanks for your help!

 

[araskas]

Probably the field name in the table could be different some thing like First_Name, Last_Name. Use Expression builder in the query design to drag those relevant fields to your query.
Or else create a query by first creating separate columns for First Name and Last Name.