Query

  • Thread starter Thread starter CGibbons
  • Start date Start date
C

CGibbons

Is there any way to share a query? I have created a
complex query that i need to email to someone so they can
use it with a table. This person is computer illiterate
and would not be able to create it themselves, with all
the expressions.

Please help
 
One way would be to switch to the SQL view and copy the text into your email.

Then the user could Copy the text
Open a new query
Paste the text into the query.
Save the query.

You could export the query to a database and send that as an attachment (if you
can get around the security features of the mail program).
The users could import the query into their copy of the database.

YOu could do all this through code, IF you had already set up the code in the
other database, but I doubt that you have or you would not be asking this question.
 
Back
Top