Selecting Only Certain Records

J

Jason

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?
 
V

Vincent Johns

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.
 
Top