Re: run a series of queries

If they're just select queries then open Query4. It will do what it
needs to do with the other ones.

Cheers,
Jason Lepack

On Jan 30, 2:02 pm, "guy" <g...@xxxxxxxxx> wrote:
i need to run a series of select queries which depend on the results of the
previous ones...i want to run the queries in an efficient way...

Now...first I need to run Qry1 (select records from tableA), then Qry2
(based on Qry1 results), next is Qry3 (select records from table B), last is
Qry4 (join results of Qry2 and Qry3).

How can i simplify the process? I hope I can run the several queries in a
faster way...

Thanks!


.

Relevant Pages

  • Re: simple parts inventory
    ... You are relying on forms and VBA to perform the function of tables and ... queries. ... My one table (transaction) performs the ... Jason Lepack wrote: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: "Favorites" tab in Access
    ... I don't use the "Favourites" group, but I do have many groups. ... If I have a bunch of queries that are all ... Jason Lepack ...
    (microsoft.public.access.tablesdbdesign)
  • Re: select * from (select * from bob) and other easy stuff
    ... If you have the views to simplify the logic then the BI tools should be ... that big with a bad design. ... Instead BI tooling produces these queries. ... based on whatever some business user came up with today. ...
    (comp.databases.informix)
  • RE: Error 3071 in Report
    ... and the grouping on the report couldn't figure a way to work with... ... way I figured to work around this, was to simplify my queries, and by this I ... I changed my crosstab query for something like: ...
    (microsoft.public.access.reports)
  • RE: Query too Complex...
    ... queries to create temporary tables, and then use the tables in the later ... simplify the FROM clause? ... Why would I use a subquery instead of adding it at ...
    (microsoft.public.access.queries)