new query or different filter

[vircalendar via AccessMonster.com]

I have a main form with three subforms. Each subform looks at the same set
of data, but from a slightly different perspective. Right now, each subform
uses a separate query as its record source, and each query is selecting data
from the same group of tables using different criteria. Other than the
selection criteria, the queries are identical.

I'm wondering if it would be more efficient to use a single query and then
use a filter in each of the subforms to differentiate my data? The tables
are large and the main form updates frequently (currently using the requery
method). Would it be faster to refresh the filters than to requery three
underlying queries?

 

[bhicks11 via AccessMonster.com]

Why do you need three different subforms if you are using the same data? Why
not just offer filter options on the one form? You could even give a button
for each filter option and requery then.

Bonnie
http://www.dataplus-svc.com

 

[vircalendar via AccessMonster.com]

Its the same data for each of three different criteria: identical demographic
data (like name, address, etc) for different groups of people. I need to see
all of it at the same time, hence the three subforms.

The question is not how to present the data but rather how to differentiate
the data sets. Are three separate queries better than one query and three
filters?

Why do you need three different subforms if you are using the same data? Why
not just offer filter options on the one form? You could even give a button
for each filter option and requery then.

Bonnie
http://www.dataplus-svc.com

I have a main form with three subforms. Each subform looks at the same set
of data, but from a slightly different perspective. Right now, each subform

[quoted text clipped - 7 lines]

method). Would it be faster to refresh the filters than to requery three
underlying queries?

 

[John Spencer]

I don't know, but you could test it and see. I suspect that three
separate queries may be more efficient.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

Its the same data for each of three different criteria: identical demographic
data (like name, address, etc) for different groups of people. I need to see
all of it at the same time, hence the three subforms.

The question is not how to present the data but rather how to differentiate
the data sets. Are three separate queries better than one query and three
filters?

Why do you need three different subforms if you are using the same data? Why
not just offer filter options on the one form? You could even give a button
for each filter option and requery then.

Bonnie
http://www.dataplus-svc.com

I have a main form with three subforms. Each subform looks at the same set
of data, but from a slightly different perspective. Right now, each subform

[quoted text clipped - 7 lines]

method). Would it be faster to refresh the filters than to requery three
underlying queries?

 

[vircalendar via AccessMonster.com]

How can I test it?

I don't know, but you could test it and see. I suspect that three
separate queries may be more efficient.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

Its the same data for each of three different criteria: identical demographic
data (like name, address, etc) for different groups of people. I need to see

[quoted text clipped - 16 lines]

 

[John Spencer]

Create two versions - one using separate queries and the other using one
query filtered.

Then try the two versions. If you see no difference in performance, go
with the simpler (in your opinion) choice. After all, if the difference
is not apparent to the user, who really cares if something is 200
microseconds faster when displaying data. That small a difference in
operation will only be of significance if you are doing many iterations
of an operation in a loop.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

How can I test it?

I don't know, but you could test it and see. I suspect that three
separate queries may be more efficient.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

Its the same data for each of three different criteria: identical demographic
data (like name, address, etc) for different groups of people. I need to see

[quoted text clipped - 16 lines]

method). Would it be faster to refresh the filters than to requery three
underlying queries?