Running queries in a sequence

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I’m trying too running a couple of queries in a sequence, but I don’t know
how to write the specific code for it. My problem is that they are really big
queries use to do calculation and some of the queries depends on the results
of the calculations of other queries so they have too run in a specific
order. How can I do that?
Thank Felipe
 
That work pretty good, but There is a small problem. The thing is that I have
a parameter that is the n ° of the contract. In the form this n° is auto
generated by access, I also want to not have to in put this number every time
I have too run the queries. I want to access to automatically know that. The
program I making have 12 tables that you have to fill and all of then are
related by this same number and all the queries add lines to an other 12
tables. My form is basic all this first 12 tables and I want access too when
I end up filling all the form and press a button to run all the queries and
relate them to the same id n° (the contract n°). Then the information
generated by all the queries I would access that thru an other form that I
still developing. Plus I don’t want the massage saying that I’m about too
adding a line to a table. Do you think that is possible???
Sorry for my English.
Thanks a lot


"Ofer" escreveu:
 
Back
Top