By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

How to run queries on a subset of records in a table?

P: n/a
I have inherited a complex database that has many dozens of queries that derive data from a people
table.

I now need to be able to run these queries (from within a significant number of forms) not on the
full dataset, but on a subset of the data in the people table.

I want to avoid having to put criteria in all of the individual queries or forms, or having to
change the data source for all the queries.

Is there anyway I can restrict the recordset without having to modify all the queries individually?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Consider a query by form (QBF). The QBF is a form in which you can enter
multiple variable parameters that are sent to your queries when the queries
are activated. The QBF is an unbound form with unbound text boxes on it
that are used to supply parameters to the queries. Multiple queries can be
fed off this form. The queries refer to the unbound controls/text boxes on
the QBF by there names so that when you fill the text boxes and activate the
queries, then the queries are filtered by whatever was placed in the text
box(es). In the criteria rows of your queries, you would place expressions
similar to this: [Forms]![frmNameOfUnboundForm]![txtNameOfUnboundTextBox]

Denny G


"Roger Green" <rc*****@mun.caNOJUNK> wrote in message
news:bj**********@coranto.ucs.mun.ca...
I have inherited a complex database that has many dozens of queries that derive data from a people table.

I now need to be able to run these queries (from within a significant number of forms) not on the full dataset, but on a subset of the data in the people table.

I want to avoid having to put criteria in all of the individual queries or forms, or having to change the data source for all the queries.

Is there anyway I can restrict the recordset without having to modify all the queries individually?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.