Which of the following expressions combines the atomic values from two fields in a LastName, FirstName format in an expression in an Access query? A)[LastName] ", "

Question

Which of the following expressions combines the atomic values from two fields in a LastName, FirstName format in an expression in an Access query?
A)[LastName] > ", " < [FirstName]
B)"LastName" & "FirstName"
C)[FirstName] & " " & [LastName]
D)[LastName] & ", " & [FirstName]

Quizplus · Accepted Answer

The correct expression to combine the atomic values from two fields in a LastName, FirstName format is [LastName] & ", " & [FirstName]. This syntax correctly concatenates the LastName field, a comma followed by a space, and the FirstName field.

Which of the Following Expressions Combines the Atomic Values from Two