3 Replies Latest reply: May 15, 2014 10:06 AM by Data Kruncher RSS

    Grabbing info from 2 rows, not all items have 2 rows.

    Amadeus23 _

      Trying to run reports that will gather the occasional 2 row information when most of them have a single row.  For example:

       

      (lol, can't get columns to line up.  Ignore the periods, they are there just to line up the columns)

       

      Name..................... ID..........Dept........Amount....YTD Amount

      John Doe.................33433.....Dept 74...$48.40.......$1,870

      Roger Smith.............15711.....Dept 12...$22.00.........$870

      Ryan Jones..............34321.....Dept 18...$18.20.........$620

      ..........................................Dept 12...$7.70...........$240

      Michelle Frances.......54255.....Dept 74....$8.40..........$170

       

       

      How can grab both rows of Ryan Jones' info?  And, on the report, insert the name and ID or Ryan Jones?

       

      Thanks