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.
 

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

Similar Threads

Fields in a query 4
Use In() Expression as Query criteria with guts from Function 1
Access Query problem 1
Simply confused - Query stopped working 7
Make-table query with around 2 ml records taking too long 0
Access 2010 append query to SQL is very slow 0
"Query Too Complex" Access 2000 help me make this one query less complex? 0
Counting multiple memberships 1

Back
Top