Selecting Only Certain Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a rating scale 0, 1 and 2 that my users are entering and I am trying
to query it buy JUST the 0, just the 1, and just the 2 using different
queries. How is this possible?
 
Jason said:
I have a rating scale 0, 1 and 2 that my users are entering and I am trying
to query it buy JUST the 0, just the 1, and just the 2 using different
queries. How is this possible?
Click to expand...

By using WHERE in SQL. (In Query Design View, put the number in the
Criteria property of a field). For example,

SELECT Table.*
FROM Table
WHERE ((Table.Scale)=2);

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Back
Top