Combining two fields

[Jacqui]

On a Report Selection form I have two fields [Client] and [ClientName].
[Client] consists of just the client whereas [ClientName] consists of Client
and ClientRegion ie:
in a query the field reads as Expr1: Client &" "& ClientName. How do I refer
to this combined field in a SELECT statement? The statement - SELECT
tblAssessment.Client &" "& tblAssessment.ClientName AS Expr1 - does not
work.

Thank you,
Jacqui

 

[Igor V. Makeev]

Hello, Jacqui!
You wrote in message on Tue, 13 Jul 2004 11:40:04 +0200:

J> On a Report Selection form I have two fields [Client] and [ClientName].
J> [Client] consists of just the client whereas [ClientName] consists of
J> Client and ClientRegion ie:
J> in a query the field reads as Expr1: Client &" "& ClientName. How do I
refer
J> to this combined field in a SELECT statement? The statement - SELECT
J> tblAssessment.Client &" "& tblAssessment.ClientName AS Expr1 - does not
J> work.

Try using + instead of &

With best regards, Igor.
ICQ: 111469481

 

[Guest]

Hi,

Use the following
SELECT tblAssessment.Client + ' ' +
tblAssessment.ClientName AS Expr1

Use Single Quotes instead of Double.

 

[Jacqui]

Thank you