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

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

Guest

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

Douglas Eckert
(e-mail address removed)
(316) 759-5647
 
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
 
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.
 
Back
Top