Query management question

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

Guest

Hello,
I have a pretty basic query efficiency question. I am wondering if it is
more efficient to create a new query that includes a smaller set of fields
that another query may contain, or if I should just pull out individual
elements of that larger query to create my 'custom' query for things such as
comboBox data.
If the sorting and other elements are the same except for the actual fields
involved, I am beginning to think it would be better to use the larger query
and pull out fields from it as I am getting a rather long list of queries
that is becoming a bit of a chore to maintain and distinguish one from
another.
Thanks in advance,
Dana S.
 
Hello,
I have a pretty basic query efficiency question. I am wondering if it is
more efficient to create a new query that includes a smaller set of fields
that another query may contain, or if I should just pull out individual
elements of that larger query to create my 'custom' query for things such as
comboBox data.
If the sorting and other elements are the same except for the actual fields
involved, I am beginning to think it would be better to use the larger query
and pull out fields from it as I am getting a rather long list of queries
that is becoming a bit of a chore to maintain and distinguish one from
another.
Click to expand...

"You win on the swings but you lose on the roundabouts".

One query with many fields is certainly easier to manage; but you'll
pay a cost in performance, since Access must retrieve a larger
recordset even if you'll in fact only be using a portion of it.

If performance is adequate, I'd use the one query for simplicity; if
it's not, use the multiple queries. I'd suggest NOT basing queries on
queries unless it's necessary; this can cause slow performance too.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Dana
Place a combo box on your form and close the combo box wizard.
Click on the ... next to the row source field in the combo
box properties sheet and create your query in the design
grid that appears. You don't have to name this query and
it won't appear in your list of queries.
Hope this is helpful.
Anna
 
Back
Top