MS Access Select Queries, Troubleshooting: Too many rows of data

D

Douglas Eckert

Despite having followed the Help menu suggestions, my MS Access query still
contains way too many rows of data. Suggestions, anyone?

Douglas Eckert
[email protected]
(316) 759-5647
 
L

Larry

Use a WHERE clause in your SELECT statement to limit the number of rows
returned (SELECT * FROM tablename WHERE criteria). Check this out in Help.
You can also open your query in SQL view and edit the text, or place the
criteria directly in your query.

Larry
 
R

Rick B

You would have to tell us what your query looks like (post the sql here) and
then tell us which records are being displayed that you feel should not.

Are you using "Or"s for multiple criteria instead of "and"s? That will
usually give you more details than you' expect.
 
Top