Select query help needed
Posted on 2007-10-09
I have a field that I query that is a Text field that stores three value all of which will either be a zero or a one.
You get the idea. I need to write a MSAccess and a SQL query to return any records that have the second value set to a 1. In the example above, this would return two records (the first and third records listed).
Can someone give me a hand on the syntax for this query in MS Access and SQL?