Joining two fields?

[ksu176]

I am working with Microsoft Access reports and am having trouble joining two fields.

For example,

I have a first name and last name fields. How do I join the two so that they show up as "last name", "first name" on the report regardless of the amount of characters in the fields. It seems like I remember there is a way to do this, but I can't come up with it.

Any help would be very much appreciated!

 

[jebry]

Hi!

You can set the text box's control source to:

= Me!LastNameField & ", " & Me!FirstNameField

Another way to do this is to create the field in a query which is the record source of the report:

FullName: LastNameField & ", " & FirstNameField

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[Ravensleach]

Concatenate (join) the fields like this

=[lastname] & ", " & [firstname]

substituting your field names for the bits in [] if need be.

 

[ksu176]

Thanks for your help!