Query

[Pass-the-reality]

In my table I have a field for FirstName and one for LastName. On a Query, I
need to show LastName, FirstName. I tried adding the below to the Query
Field, but it does not come up correctly

Associate: [LastName] And [FirstName]

What do I need to add?

 

[David9746]

Try this in your query field


Associate: [LastName] & " " & [FirstName]

 

[Dirk Goldgar]

In my table I have a field for FirstName and one for LastName. On a
Query, I
need to show LastName, FirstName. I tried adding the below to the Query
Field, but it does not come up correctly

Associate: [LastName] And [FirstName]

What do I need to add?

Associate: [LastName] & ", " & [FirstName]