T
the_dude
Hi,
I am trying to run two queries consecutively.
I use access as a front end to a oracle DB. Date fields are not indexed so I
thougth I design a form asking the user to enter start date and end date. The
first query (make table) would look up a specific field containing date codes,
which are indexed. Using this date code field improved the speed of the query
by 50% (from 12 mins to 6 mins).
Afterwards I would like the min and max result of the date code field to be
used as a criterium (Between "date_code_min" And "date_code_max") in the
second query which would look up the information.
However, I am not sure how to run two queries consecutively without user
input and do not know how to use min, max results from query1 as criteria in
query2?
I would appreciate any help.
Kind regards.
I am trying to run two queries consecutively.
I use access as a front end to a oracle DB. Date fields are not indexed so I
thougth I design a form asking the user to enter start date and end date. The
first query (make table) would look up a specific field containing date codes,
which are indexed. Using this date code field improved the speed of the query
by 50% (from 12 mins to 6 mins).
Afterwards I would like the min and max result of the date code field to be
used as a criterium (Between "date_code_min" And "date_code_max") in the
second query which would look up the information.
However, I am not sure how to run two queries consecutively without user
input and do not know how to use min, max results from query1 as criteria in
query2?
I would appreciate any help.
Kind regards.