Stupid question

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi everyone

Supose I have a table T and a request R1 that
procude the Table T1=R1(T).
Suppose I have a request R2 that produce
the table T2=R2(T1).

Under Access I can run request R1 and after
R1 is completed I can run R2 to obtain
T2. Ok.

If I change something in T and want to
know what new T2 is, I must proceed
in the same way: running R1, running R2.

Is there a way to do the whole thing
in juste one run ?

Alex
 
Sorry, but your question is not clear. What is R1? and R2? are they
make-table queries? are they functions?

Please restate your question so that we can better understand what you seek
to do.
 
If they're both select queries, then just run R2 by itself. Assuming that
it's using R1 as a data source, it'll cause R1 to run as well.
 
All you have to do is rerun query R2. Access will automatically run R1 in
the process of running R2.
 
Back
Top