ELECT "" As FieldInfo, NullID As [FieldIDNumber], "" As ProjectName From tblDummy UNION ALL SELECT tblField.Treatment1 & "- " & tblField.Treatment2 & "-" & tblField.Treatment3 & "-" & tblField.Replication AS FieldInfo, tblField.FieldIDNumber, tblField.ProjectName FROM tblField ORDER BY FieldIDNumber;