Adding a comma for salutation

[Guest]

I created a report, which is a letter to our employees, that automatically
populates the names of the employees in the salutation section of the letter.
The names being populated is based on a query. The question is, how can I
have a comma, which is a label in the report, move based on the length of the
name?

For example: The report is set up this way: "Dear ,". When I run
the query to populate the names, the output goes like this: "Dear David
Johnson ,". The comma stays in place while having the employee name field
sized to the longest name on the list. The bottom line is, I'd like for the
comma to automatically adjust its position so that the output would always be
something like this: "Dear David Johnson,".

The employee name field has a property set to "yes" for "Can Grow", but that
still doesn't fix the comma placement problem I'm having.

I hope my explanation made sense. Any suggestion you can provide will be
greatly appreciated.

Thanks,
Nyla

 

[Douglas J. Steele]

Add the comma to the name in a query, and use that query as the report's
RecordSource.

 

[IUnderstandSomething]

I created a report, which is a letter to our employees, that automatically
populates the names of the employees in the salutation section of the letter.
The names being populated is based on a query. The question is, how can I
have a comma, which is a label in the report, move based on the length of the
name?

For example: The report is set up this way: "Dear ,". When I run
the query to populate the names, the output goes like this: "Dear David
Johnson ,". The comma stays in place while having the employee name field
sized to the longest name on the list. The bottom line is, I'd like for the
comma to automatically adjust its position so that the output would always be
something like this: "Dear David Johnson,".

The employee name field has a property set to "yes" for "Can Grow", but that
still doesn't fix the comma placement problem I'm having.

I hope my explanation made sense. Any suggestion you can provide will be
greatly appreciated.

Thanks,
Nyla

With Excel and Access it is very easy to make a text like you want:
Ex: =[FirstName} & " " & [LastName] & ", " gives Paul Johnsen,

Hope it helps!

Hans Kristian Eide