R
Raj
I am using 3 queries for to get my monthly totals on equipment for projects.
The first is a crosstab query to get monthly totals for equipment and the
second is a select query used to total the columns in the crosstab and the
third is a UNION query to tie them together. Now the problem, when I created
the Total query I was not able to use * (ALL Fields) since you can not use *
with a Total query. So since I created it last month it only shows Jan -
Sept. Is it possible to create a Total and Union query that will updated
with the current month like the cross tab query?
The first is a crosstab query to get monthly totals for equipment and the
second is a select query used to total the columns in the crosstab and the
third is a UNION query to tie them together. Now the problem, when I created
the Total query I was not able to use * (ALL Fields) since you can not use *
with a Total query. So since I created it last month it only shows Jan -
Sept. Is it possible to create a Total and Union query that will updated
with the current month like the cross tab query?