expression to eliminate all but the first letter of last name

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

Guest

Hi,
I need to generate a report that has the customers first name but only the
last initial for confidentiality reasons. I thought about adding another
field to the customer table for just the initial, but I am sure their is a
better more efficient way using an expression in the report or the report
based on a query with some sort of expression as part of the criteria. Any
suggestions?
Thanks
 
Hi,
I need to generate a report that has the customers first name but only the
last initial for confidentiality reasons. I thought about adding another
field to the customer table for just the initial, but I am sure their is a
better more efficient way using an expression in the report or the report
based on a query with some sort of expression as part of the criteria. Any
suggestions?
Thanks
Click to expand...

No need for an additional field. Just store the firstname and the
lastname in 2 separate fields in the table.

Use an Unbound text control to display the name combination in the
report.

=[FirstName] & " " & Left([LastName],1)
 
Back
Top