I have a query1 that is gathering information from another,query2, and about 3 tables. Everything was working fine until I linked this query2 to the other query1. Once I did this and ran query2, it showed 4000 records, when it should have been showing about 700.

I then did a sort(just in the query normal view/not design) and then it showed only 700 records!??

I ran query2 again and the same thing happened. So, I exported all 4000 records to Excel(so that I could try to figure out if my records were being duplicated or what). I found that the items from query1 were each listed 33 times, instead of once. I then assumed I did something wrong in creating query1. So, I went back to it.

I had some joining-so I tried to change the methods of joining (I assumed this is what I did wrong to begin with). Ultimately, it wouldn't let me use any other joining options, so I used what I originally had.
-So, at this point, I'm back to what I started with.

I ran query2 again and it showed 700 records-exactly what it should've shown. Yet it didn't show this the first time I ran the query!

Any ideas as to what could be going on??? Has this happened to anyone else?

Now this is odd too. In my query2, which is now showing the correct number of records. In design mode, I have it sorting on one of the columns. So, I did this by clicking on "ascending" on sort-in the main design mode screen-under the field for my column. When I run query2, it doesn't show it sorted.

In the regular view(not design mode) I can click on the column, right click and sort. Save this and then reopen query2 and everything is sorted still. After doing this, when I go into design mode, I don't see anything showing that it's sorting in any different manner than it was before. My column in design mode that I was trying to sort on, still says "ascending". I'm assuming there must be another place for me to sort? Help!

Thanks in advance for any input!

Does one of your tables have 33 records in it? It sounds like you're getting a cartesian product, which is when two unrelated tables are put into a query. For every line of tableA, you get every line of tableB.

query1 may not be the problem, query3 (the one that joins query1 & query2) might be. Make sure the linkage between the two queries there is correct. Otherwise post a bit more information about the joins you have and maybe someone will spot what's wrong.