Hello,
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.
Regards,
Joachim