Hi all,

I'm having a hard time wrapping my brain around a bit of a difficult cross-reference report.

What I'm looking to build is below -- it's a summary grid of payments grouped by month in columns, cross referenced by payments grouped by assignment months, with a liquidation column.

I'm using the CROSSTAB report posted in Inside Sesame a long way back, but I need to modify this.  So my first questions to tackle this are:

- how can I group my payments by month?
- how I can I have a crosstab report go grab values from another form?

Thanks!

      2010-12       2011-01       2011-02       2011-03       Total Listed        Payments      LIQ
2010-12      $8,321.01      $16,543.91      $22,839.11      $15,778.09      $449,814.35      $63,482.12      14.11%
2011-01       $               -        $9,374.46      $20,185.96      $12,199.58      $308,377.24      $41,760.00      13.54%
2011-02       $               -         $               -        $9,499.03      $11,416.93      $301,855.94      $20,915.96      6.93%
2011-03       $               -         $               -         $               -        $7,456.42      $215,719.46      $7,456.42      3.46%
                                         
     $42,054.95      $62,056.63      $94,011.91      $56,442.97      $2,007,055.45      $279,151.50      13.91%