Which of the following criteria uses the correct syntax for a Date/Time field in a query?

Question

Quizplus · Accepted Answer

In Microsoft Access, Date/Time fields require the pound symbol (#) to indicate that the value is a date. Therefore, choice C is the correct syntax for a Date/Time field in a query. Choice A uses percent symbols, which are used for wildcard characters in Access, and choice B uses greater than and less than symbols, which are not applicable for date values. Choice D uses quotation marks, which are not the correct syntax for date values in Access.

Which of the Following Criteria Uses the Correct Syntax for a Date/Time