Two fields as One

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

Guest

I have a query with a lastname and firstname field. In my report, I want the
two fields to appear side by side as lastname, firstname. Regardless of the
lastname length, I want only a comma and one space between it and the
firstname. How can I do this?
 
One way is to use a calculated field in the query.

Field: FullName: [LastName] & ", " & [FirstName]
 
In your report, the textbox should have a Control source with:
=[Lastname] & ", " & [FirstName]

I'm assuming that everyone has a first name, otherwise you'll have to add an
IIf statement in the expression to avoid:

Smith,
Doe,

Make sure the query that the report is based on includes the firstname and
lastname fields.

Ray
 
Back
Top