View Single Post
  #3 (permalink)  
Old February 20th, 2007, 10:23 AM
leehambly leehambly is offline
Friend of Wrox
 
Join Date: Sep 2003
Location: Salisbury, Wiltshire, United Kingdom.
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to leehambly
Default

Mitch,

Not knowing exactly where your data comes from, I wil try to help...

If you can get your source data into the format:

Fields:
Agent
Period (MTD, YTD)
Section (Life, Annuities, etc)
Value

You should be able to UNION the two sets (ie: MTD and YTD) together. Now put a crosstab on the union to get your output in that format.

Alternatively, you could do a monthly (including the current month to date) report for the current year (to date) and simple remove all but the current month. Year to Date is simply a total field.

HTH

Lee
Reply With Quote