John, My client wanted a report to look at his customer sales for the previous year with a column for the current selected month. So the if the user selected May 2008 the end result would be: Customer SalesMay2007 SalesJun2007 SalesJul2007... to SalesApr2008 SalesMay2008 Joe & Co $1000.00 $2589.01 $153.00 $1545.98 $1201.77

Hello, I don't know if I can explain this properly, but I have a form with two textboxes, [selectMonth] and [selectYear], which are Integers. The underlying table has sets of fields, [Mo12] [Year12] [Sales12] ... to ... [Mo1] [Year1] [Sales1] I have a SOURCE table with fields [Month] [Year] [Sales] which will be directed to the pertinent fields in the form's table according to