Hello,

Am trying to figure out how to concatenate two fields ( eg Surname, FirstName) into one separated by a comma. Can this be done via a query or is a report required?

Create this query in Northwind to see the technique:

SELECT Employees.LastName, Employees.FirstName, [LastName] & ", " & [FirstName] AS FullName
FROM Employees;

Bob is giveng you a SQL String for a query. This may confuse you if you are not used to working with it. His example is a correct way to do it.

Try going to your query in design view and add a Field Expression:

FullName:[Surname] & "," & [FirstName]

The above is basically the same theory as Bob gave if you choose to view the finished query in SQL view.

HTH
RDH