To create a datasheet that lists all herbs that are Perennials,Jorge will create a new query. The Perennial field has a data type of Yes/No. Which criterion should Jorge use in the query for the Perennial field?
A)Yes
B)No
C)check=yes
D)'yes'

Question

To create a datasheet that lists all herbs that are Perennials,Jorge will create a new query. The Perennial field has a data type of Yes/No. Which criterion should Jorge use in the query for the Perennial field?
A)Yes
B)>No
C)check=yes
D)'yes'

Quizplus · Accepted Answer

Jorge should use the criterion "Yes" for the Perennial field, as this will only show results where the Perennial field has a value of "Yes". The other options are incorrect as they either include results where the field is null or could potentially include results where the value is not actually "Yes".

To Create a Datasheet That Lists All Herbs That Are