You want a query's result to include dates after December 1,2013.What will the properly formatted criteria look like in the query?
A) 12/1/2013
B) =#12/1/2013#
C) #12/1/2013#
D) #12/1/2013#

Question

You want a query's result to include dates after December 1,2013.What will the properly formatted criteria look like in the query?
A) >12/1/2013
B) =>#12/1/2013#
C) >#12/1/2013#
D) #12/1/2013#

Quizplus · Accepted Answer

The proper way to enter a date criteria in Access is by enclosing it in pound signs (#). The > symbol means "greater than," and December 1, 2013, should be enclosed in pound signs to indicate that it is a date. Therefore, the correctly formatted criteria is >#12/1/2013#.

You Want a Query's Result to Include Dates After December