Which of the following criteria uses the correct syntax for a Date/Time field in a query? A) %5/7/2021% B) 5/7/2021

Question

Which of the following criteria uses the correct syntax for a Date/Time field in a query?
A) %5/7/2021%
B) >5/7/2021<
C) #5/7/2021#
D) "5/7/2021"

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