Adding a WHERE clause with a text modifier

[willkr]

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

[June7]

Why would you use table.field? Surely table is not named "table" and field is not named "field"?

SELECT * FROM YOURtablename WHERE locale = "State";

should work

[willkr]

OK June7, bear with me and forgive me for long field names. Here's the exact SELECT Clause for the form (not the locale form, but the savings form):

SELECT tblSavingsDepWith.[Savings DepWith Number], tblSavingsDepWith.[Savings DepWith Date], tblSavingsDepWith.[Savings DepWith Amount], tblSavingsDepWith.[Savings DepWith Who], tblSavingsDepWith.[Savings DepWith Cleared], tblSavingsDepWith.[Savings Account] FROM tblSavingsDepWith WHERE tblSavingsDepWith.[Savings DepWith Type]=”With” ORDER BY tblSavingsDepWith.[Savings Withdr Date];


Now, what do I need to change in the WHERE clause to make it work?

[CJ_London]

Cross posted here
https://www.access-programmers.co.uk.../#post-1899988