D
dar
Previous posts have been very helpful and I have run my Union query
successfully as far as the prompts go.
Now here's phase two.
Since I am asking for a Sum Total in each of the Union queries, I would like
to know how to get the individual results in one location. Should it be a
form or report and how do I get the five totals , one under the other.
Final result should look something like this.
SumofPT SumofOT SumofST Range
75 30 15 5 Day
120 90 60 14 Day
160 100 75 30 Day
300 100 75 60 Day
350 130 120 90 Day
Thanks: I am extremely thankful for your help
successfully as far as the prompts go.
Now here's phase two.
Since I am asking for a Sum Total in each of the Union queries, I would like
to know how to get the individual results in one location. Should it be a
form or report and how do I get the five totals , one under the other.
Final result should look something like this.
SumofPT SumofOT SumofST Range
75 30 15 5 Day
120 90 60 14 Day
160 100 75 30 Day
300 100 75 60 Day
350 130 120 90 Day
Thanks: I am extremely thankful for your help