Asked by CECILIA SIOCO on May 07, 2024

verifed

Verified

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"

Date/Time Field

A type of database field specifically designated to store dates and times, allowing for time-related operations and queries.

  • Identify the structure and creation of calculated fields and conditions in queries.
verifed

Verified Answer

ES
Erika SaundersMay 12, 2024
Final Answer :
C
Explanation :
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.