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
--
Mark N

On Wed, 2 May 2007 08:34:00 -0700, Mark wrote:

> 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)
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail