Running query in another database

[RoBo]

Could anyone help me with the following problem:

I created a form in a database. This form is used to specify criteria for a
number of queries. The queries are executed by clicking a button on this
particular form. The queries being executed reside in the same database as
the form.

Is it possible to pass the query criteria to a number of queries that reside
in another database? If yes, how do I do this.
E.g. In the annual database I analyse data in the first quarter of the year
and in the annual-1 database, I would like to run the same queries to compare
the same quarter of the previous year. Now I have to run the queries in both
databases with exactly the same query criteria. It would be easier to input
the criteria once and run the same queries in both databases.

Thank for any suggestion/solution in advance,

Ron

 

[Piet Linden]

Could anyone help me with the following problem:

I created a form in a database. This form is used to specify criteria fora
number of queries. The queries are executed by clicking a button on this
particular form. The queries being executed reside in the same database as
the form.

Is it possible to pass the query criteria to a number of queries that reside
in another database? If yes, how do I do this.
E.g. In the annual database I analyse data in the first quarter of the year
and in the annual-1 database, I would like to run the same queries to compare
the same quarter of the previous year. Now I have to run the queries in both
databases with exactly the same query criteria. It would be easier to input
the criteria once and run the same queries in both databases.

Thank for any suggestion/solution in advance,

Ron

You could link to the tables in the other db and run from within the
current db.