Running query in another database


R

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
 
Ad

Advertisements

P

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top