Combining fields

[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.

 

[Van T. Dinh]

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.

 

[John Vinson]

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.

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]

 

[Guest]

Thanks John.

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.

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]