Getting Data From omitted records
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?
|Total Current Year|
|Total Last Year|