Query based on other query

[SunTop]

Hello everyone,

I have created a number of queries that are based on each other, like so :
Query 7 based on Query 6
Query 6 based on Query 5
Query 5 based on Query 4
Query 4 based on Query 3
Query 3 based on Query 2


Query 2 based on Query 1

Then I have noticed that Query Number 7 is getting slow when you scroll through the records, I don’t have many records in this database (only 98 records).
The Query opens quickly, but the scrolling is slow, I could have combined the quires in a smaller number of quires, I did not need that many quires, I only separated them because it was easier for me to design them in that way.
Is designing quires in this way causes it to slow down in scrolling records ?
One more thing to note, I used long names for the fields in the tables and quires, does that cause the database to slow down ?

[June7]

Why are you doing queries like this? Are you just applying filter to each? Perhaps this article will be helpful http://allenbrowne.com/ser-62.html

I doubt length of field names is reason for slow performance. But I avoid long names regardless.

[orange]

If you want advice on design, I suggest you clearly describe what you are trying to do in simple, plain English.
Once readers understand what you are trying to accomplish, they may offer options for how it might be done with Access.