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

Defining a filter by table values

P: n/a

I'd like to use data from a table to define a filter.
In detail, each table value should be used to split up the data within a
query. For example, if the table contains the items 100 and 200,
three filters should be applied one after another to extract those data
sets belonging to the range below 100, from 100 to 200, and above 200,
resp. from a query.
However, later on the data should be divided by approx. 15 frequently
changing values. That's why I'd like to read them directly from a table
instead of editing the query's draft each time.
I should note I'm using Access 2002, whereas the database in the end
will have to work in Access 2000.

Thanks for any helpful advice, no matter which way it goes.

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.