How come my statement is getting marked wrong? The question is:
Create a query based on the
tblPurchasetables that will concatenate the member’s first and last names (separated by a space) followed by the date they made a purchase. Name the concatenated field
Purchase Details. Use a comma to separate the full name and date, in that order. Save your query as
qryPurchaseDetailsand then close the query.
My answer is:
Purchase Details: [FirstName] & " " & [LastName] & "," & [PurchaseDate]
When I run it on Access, it works fine but the grader is marking me wrong. Any assistance?