Unused tables in queries

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

Guest

I currently have queries that use two or more tables. Sometimes I want one of
the tables to remain in the queries but without any join properties or links
to the other tables in each query and no selection made from that one table.

The problem is when I run these queries, the output is wrong because it is
still reading from the disjoined table, so currently I have to go into each
query and delete the table from each query before it reads right.

The table is useful when I want to see the results from another angle so I
need to put it back in when I need it. These queries are run frequently and
are quite a lot; meaning it is time consuming manipulating the queries like
this.

I am just a beginner in VBA, so any answers requiring it may need to be
quite explicit. I have designed this database just using criteria
expressions and the likes.

Thanks for any and all help.
 
Ese

The best advice would be to keep it simple by creating additional queries
that contain the tables you want to join sometime. An additional query to
run without the join. This solution give you exactly what you need at any
time without a need to update the query.
 
Back
Top