Combining data - remedial question :)

[Guest]

I have the fields LastName and FirstName in a datatable.
I need to combine this information into the format "LastName, FirstName*".
Can anyone help me do this?
Thanks!
Andrea

 

[Allen Browne]

In query design, type this into a fresh column in the Field row:
[LastName] & ", " + [FirstName]

 

[Guest]

You might want to check that everyone has a first and last name. In our
organization there is one person with only a single name.

-Dorian

 

[Guest]

Thanks Allen!
Is there a way to include the "*" after the [FirstName]?

In query design, type this into a fresh column in the Field row:
[LastName] & ", " + [FirstName]

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have the fields LastName and FirstName in a datatable.
I need to combine this information into the format "LastName, FirstName*".
Can anyone help me do this?
Thanks!
Andrea

 

[Allen Browne]

I don't think I understand that question.

This is displaying fields.
There is no criteria here.
So I don't follow the idea of adding a wildcard.

If you literally want an asterisk attached to the end of everybody's first
name, go right ahead and add it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks Allen!
Is there a way to include the "*" after the [FirstName]?

In query design, type this into a fresh column in the Field row:
[LastName] & ", " + [FirstName]

I have the fields LastName and FirstName in a datatable.
I need to combine this information into the format "LastName,
FirstName*".
Can anyone help me do this?