how do i only get last and first name when it is not a subtext

[Guest]

When I am trying to do a report in access any my field names are first last
but need those both together to make on like this Smith, Joe

 

[David Lloyd]

Janeda:

I am assuming you have two different fields, one with the first name
([FirstName] for my example) and last name ([LastName]). You can set the
Control Source of the text box in the report as follows:

=[LastName] & ", " & [FirstName]

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


When I am trying to do a report in access any my field names are first last
but need those both together to make on like this Smith, Joe