If you want to select records containing the text Consulting in the ProjectType field, how does Access save the criterion in the query grid of Query Design View?
A)"Consulting"
B)#Consulting#
C)[Consulting]
D)(Consulting)

Question

Quizplus · Accepted Answer

In Access, when specifying criteria for text fields in the query design grid, the text should be enclosed in double quotes. Therefore, "Consulting" is the correct format.

If You Want to Select Records Containing the Text Consulting