Here you go:
SELECT [Assignments - Writing].[CONTRACT ID NUMBER], [Assignments - Writing].CONTID, [Assignments - Writing].[PUB CODE], [Assignments - Writing].MODULE, [Assignments - Writing].[JOB NO], [Publication List].Publication, [Last] & ", " & [First] AS ContName, [Assignments -...