Reporting Most Current Sales
I track historical customer sales and have fields for 2012, 2011...2008, sales etc. I do not have 2012 sales for each record but do have one of the previous years. I need to creat a field that will look to several other fields and pick the most current data to display. So if 2012 Sales is null, it will look to 2011 Sales and if that is null, look to 2010. Hopefully this is pretty easy to do.