Link or Field - Queries

[bhipwell via AccessMonster.com]

Hello,

I have a massive query that is used to generate a report. The query is made
up of many small queries, each compiling information for various products.

In terms of speed, is it better to:

A) link the queries in design view and select the data I want
B) in the main query, use the field to build a reference to the data I want
in another query

Thanks in advance!

BH

 

[Jeff Boyce]

There are so many other variables that might have an effect...

What happens when you try it both ways?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[bhipwell via AccessMonster.com]

What happens when you try it both ways?

I don't think I am going to take the time to try it both ways as I was
looking for an answer to help me make my decision which way to go. This is
actually more of a curiosity than anything else. This older database needs
cleaning up including some normalization. But during clean-up, this question
popped up.

BH

 

[Jeff Boyce]

I wasn't trying to dodge your question, I really meant that there are a
large number of other variables that can impact performance in this
situation.

As a small example, are the "join" fields indexed in the underlying tables?
Are the "select" and "sort" fields indexed?

Are you using any functions? Are the functions "local" to Access?

Is the data located in an Access back-end? On a network? With what kind of
network configuration?

(and that's just a start!)

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/