View Single Post
  #1 (permalink)  
Old February 19th, 2007, 06:39 PM
Mitch Mitch is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: South Bend, Indiana, USA.
Posts: 149
Thanks: 0
Thanked 0 Times in 0 Posts
Default Month and Year to Date on a Report


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.

Code:
           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 tried to attached my database as well as a jpg that shows exactly what report layout I want, but there is no upload utility.

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.

Mitch
__________________
Mitch
Reply With Quote