Between Criteria

[Guest]

I am running a make table query against one DB2 table and then running an
append query against a separate DB2 table to join data from the two tables
together. In both queries I use a between operator to select the period of
time for the data. The dates for both queries are always the same. When I use
the the Between operator I need to selct the dates each time I run each
query. Is there a way to enter the dates once and then use those same dates
in the second query? --
Randy

 

[Guest]

Use unbound text boxes in a form and reference in your queries.