I'm using a SELECT statement in a form to specify which data to get. One of the fields is a short text field that can be either "State" or "Local." I've tried a WHERE clause that says
WHERE table.field= "State" to isolate only those records that have the locale set to State. I keep getting errors. I tried a single quote instead of a double quote and I've tried a double-double quote, but they all give me errors. How can I specify only records with locale = State?
willkr