make query

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

Hi all,
Im trying to make a dinamic query(basing on several of other querys),is
there a way to make a query the same as to make a table so if its
needed it will be destroyes?
 
Your question is vague. What do you mean "is build"

If you mean persist the results of running a query then the answer is
"No" unless you run a maketable query in which case you've made a
table.

You can open the query design wizard by going to the Database|Query
window and clicking "New" When it opens, switch to SQL view and write
your query. Then save that query with a name. To get the data run
the query.

HTH
 
yes, i know how to make a query in the normal way,my issue is that i
will be able to make dinamic as posible the access so it will mostly be
with a vb code and less use constant queries
 

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

Access Query criteria based on other field of the same query 0
Buidling query inside of a query using docmd.RunSQL. 1
neutralizate culomn in a query 4
Ansswer for my question 1
Data Mismatch in Excel 2010 4
MS Access Date/Time Calculation After Midnight 1
Query Parameter using multiple options 0
Pass Through Make Table 7

Back
Top