My query is too slow/freezes on first page.

[RZ15]

Hi guys,

I'm attempting to run a query that I made and it is running way too slow. Everything seems to work fine until I add in a table (dbo_INIH) and a field from that table (TAKBY). The reaction I get when I add those fields is weird. Within 2 minutes the first page of the query will show, which is normal for my queries. I suppose Access decided that it will be easier to show the first page and then load the rest of the records, so at this point I would attempt to click the button that takes me to the last record. However, when the first page loads, it kind of freezes and when I move the mouse around the screen, the cursor doesn't change and when I try and click a button, it won't click because it is frozen. Again, this only happens when I add that field into the query (and the field is essential).

Any suggestions on how to speed this up?

Thanks in advance,

Raza

[cori25]

This is occurring because there is so much data. It will go to the last record if you let it finish. If you have already pulled in your data based on specific criteria so that it will not pull in everything, then the only other option is to make it "Group By". This may speed things up a little.

Otherwise, it may be the table you are adding in(dbo_INIH). Instead of bringing this in directly, create another query and pull in this table (dbo_INIH) and all the fields, now select "Make table query" and run it.

Now, instead of bringing in the original table(dbo_INIH), bring in the table you created off of this. In some instances this speeds things up.

Let me know if this helps.

Thanks

[RZ15]

This is occurring because there is so much data. It will go to the last record if you let it finish. If you have already pulled in your data based on specific criteria so that it will not pull in everything, then the only other option is to make it "Group By". This may speed things up a little.

Otherwise, it may be the table you are adding in(dbo_INIH). Instead of bringing this in directly, create another query and pull in this table (dbo_INIH) and all the fields, now select "Make table query" and run it.

Now, instead of bringing in the original table(dbo_INIH), bring in the table you created off of this. In some instances this speeds things up.

Let me know if this helps.

Thanks

The Make table query worked beautifully, thank you very much.