Combining Fields.

[therodzone]

I'm using a Query to sort a persons FirstName, and LastName fields in Alpha order. Then I added in the query to combine the two fields like so :

Name: [LastName] and [FirstName]

My output is like this..

LastNameFirstname

How do combine the two as I did, but seperate them with a comma??

Thanks!

 

[Sohaila Taravati]

Name: [LastName] & " "& [FirstName]

 

[therodzone]

Now that was really simple. Thanks, I'm a newbie as you can tell.