expression to eliminate all but the first letter of last name

[Mark]

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

 

[fredg]

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

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)