Stupid question

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
 
K

Ken Snell [MVP]

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.
 
K

Ken Snell [MVP]

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.
 
D

Dale Fye

All you have to do is rerun query R2. Access will automatically run R1 in
the process of running R2.
 
Top