G Guest Nov 9, 2005 #1 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
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
D David Lloyd Nov 9, 2005 #2 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
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
