M
mistux
I need a Report that shows the Month To Date and the Year To Date per
each Category at the top and along the left all of the individual
people.
Life Annuities Securities Group Total
Agent MTD YTD MTD YTD MTD YTD MTD YTD MTD YTD
Bob 25 50 0 0 10 30 0 0 35 80
Jim 0 50 10 10 15 45 100 110 125 215
Totals 25 100 10 10 25 75 100 110 160 295
I have tried to attach my database as well as a jpg that shows exactly
what report layout I want, but there is not upload feature.
I have made two seperate queries, one for MTD and YTD but I have not
been able to "merge" them to make the report that I need.
I even tried the Crosstab wizzard but that did not work for me either.
each Category at the top and along the left all of the individual
people.
Life Annuities Securities Group Total
Agent MTD YTD MTD YTD MTD YTD MTD YTD MTD YTD
Bob 25 50 0 0 10 30 0 0 35 80
Jim 0 50 10 10 15 45 100 110 125 215
Totals 25 100 10 10 25 75 100 110 160 295
I have tried to attach my database as well as a jpg that shows exactly
what report layout I want, but there is not upload feature.
I have made two seperate queries, one for MTD and YTD but I have not
been able to "merge" them to make the report that I need.
I even tried the Crosstab wizzard but that did not work for me either.