TIP: Notice that Access automatically surrounded the FL criterion with double quotes. That's because the State field stores text data. In database query language, double quotes signify a string of text.
If this field held date data, Access would have surrounded it with hash marks (#).
If the field stored number data, Access wouldn't have added anything.
-
On the Toolbar, click the
icon.
The query results should look like this:
It has returned all customers who live in the State of FL.