Combining fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I still haven't bought the book ( Yet ). But I needs to know. How do I
combine two fields to provide one expression. For instance. I have two fields
in a form:

[FirstName] and [LastName]

I want to combine these two fields to appear together on a report:

[FirstName LastName], as one field.
 
In the Query being used as the RecordSource for the Report, create a
Calculated Field like:

FullName: [FirstName] & " " & [LastName]

and use FullName as the ControlSource for your TextBox on the Report.
 
I still haven't bought the book ( Yet ). But I needs to know. How do I
combine two fields to provide one expression. For instance. I have two fields
in a form:

[FirstName] and [LastName]

I want to combine these two fields to appear together on a report:

[FirstName LastName], as one field.
Click to expand...

Set the Control Source property of a textbox to

=[FirstName] & " " & [LastName]

The & operator concatenates string values; the " " inserts a blank
between the names so you get John Vinson instead of JohnVinson.

John W. Vinson[MVP]
 
Thanks John.

John Vinson said:
I still haven't bought the book ( Yet ). But I needs to know. How do I
combine two fields to provide one expression. For instance. I have two fields
in a form:

[FirstName] and [LastName]

I want to combine these two fields to appear together on a report:

[FirstName LastName], as one field.
Click to expand...

Set the Control Source property of a textbox to

=[FirstName] & " " & [LastName]

The & operator concatenates string values; the " " inserts a blank
between the names so you get John Vinson instead of JohnVinson.

John W. Vinson[MVP]
Click to expand...
 
Back
Top