4 Replies Latest reply on May 3, 2015 8:31 AM by philmodjunk

    Getting Data From omitted records

    Christic

      Title

      Getting Data From omitted records

      Post

      Not sure if  thiscan be done, but here is what I have...

      Small database with 6 fields for each month and a calculation for each giving me the sum,  there are 10 records for each year, I select a year from a drop down list and search for  specific year.  So I now see just the 10 record for the year.  but I would also want to see the totals from the year before.  Is this possible?

       

      Clarence

      Example

       

                                                                                                                                                                                                                                                                                               
      Jan           1            
      Feb2
      Mar3
      Total Current Year 
      Total Last Year