Question

In a query, which of the following statements is TRUE regarding delimiters in the criterion of a field? Complete Points out of Select one: 1.00

a. Text data types must be enclosed in pound signs. F Flag question
b. Number data types that use plain digits require no delimiter.
c. Date/Time data types must be enclosed in quotations.
d. Number data types must be enclosed in single quotes.

Answer 1

In a query, number data types that use plain digits require no delimiters.

Step-by-step explanation:

In a query, the statement that is TRUE regarding delimiters in the criterion of a field is b. Number data types that use plain digits require no delimiter.

When working with number data types in a query, such as integers or decimals, you do not need to enclose them in any delimiters like pound signs (#), quotations (''), or single quotes (''). Simply enter the plain digits as the criterion. For example, if you want to find all records where the age is greater than 25, you can enter 'age > 25' without any delimiters.