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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Too many active users 3
Aligning beyond "Joining" in query--forcing blank rows to appear 11
Access 2003 Question 2
query which selects data at an intersection 9
Make-table query with around 2 ml records taking too long 0
Why no 'Export' functionality? 5
Query multiple data from source table 2
Query too complex or bringing back too few items 5

Back
Top