how do you resize a field in a query that is concatenated

[Guest]

I'm trying to adjust the size of a field (last name, first name) that has
been concatenated. I trying to adjust the size of the last name portion, for
the query, so the combined field isn't so big?

I'd appreciate any help.

 

[Rick B]

Your post is rather vague. Are you saying you want to show only the first
XX characters of the last name, then a comma, then a first name?

If so, do something like...

=Left([LastName],10) & ", " & [FirstName]

 

[kerry_ja]

Hi Wes,

It sounds like you are saying you just want part of the last name, if
so, when concatenating use the left function as so:
let Field=left([Last Name],10) & ", " & [First Name]

 

[RobFMS]

For the question that you have asked, I presume you are only wanting to show
'X' amount of characters of the last name.

Try:

Left$( [lastname], X ) .... Where 'X' is the number of characters you
want to show.

HTH

--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com