Merge fields from Table in Report

[Sven Seljom]

Wrong e-mail in previous message:

Hi, does anybody know how to merge two fields into one in a Report?
Specifically I have a scenario where I want to make a report which contains
both first name and last name and show both fields in one box.

I can of course make a new column in the table, and merge the first and last
names there, but it must be a way to do this directly in the Report as well.

Any thoughts?

Sven

[Rick Brandt]

"Sven Seljom" <sv**@seljom.no> wrote in message
news:3p******************@news4.e.nsc.no...

Wrong e-mail in previous message:

Hi, does anybody know how to merge two fields into one in a Report?
Specifically I have a scenario where I want to make a report which contains
both first name and last name and show both fields in one box.

I can of course make a new column in the table, and merge the first and last
names there, but it must be a way to do this directly in the Report as well.

Drop a new TextBox on the report with a ControlSource of...

=[FirstNameField] & " " & [LastNameField]

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Sven Seljom]

Thanks Rick!

I get an #Error in return when I do this. The fields show up fine one by
one, bur when I join them with & it won't work.

Sven

[Rick Brandt]

"Sven Seljom" <sv**@seljom.no> wrote in message
news:ne******************@news4.e.nsc.no...

Thanks Rick!

I get an #Error in return when I do this. The fields show up fine one by
one, bur when I join them with & it won't work.

Make sure the control's name is not the same as either of the field names in the
expression.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Sven Seljom]

Quite,

I got it to work now. You where right, in the first place. What I didn't do
though was to include the name of the table. When I did that it worked:

[tblCustomer!firstName]& " " &[tblCustomer!lastName] it worked beautifully.

Thanks again!

Sven