We finally got our Access program up and running and now when I use the Gross YTD sales off the BKARCUST table it's giving me the 2006 numbers and not 2007.  Same goes for the LTD is 2005 instead of 2006.  How do I get the numbers to move forward a year?  Am I supposed to run a utility report???

Those numbers match the reports when we run the SA-D Customer Summary.  There should be a way for the Gross YTD to be the current year.  I know we used to use it in the past years before our Access quit working.  We want to be able to get a total number on the sales instead of all of the transactions for the year.

The SM-J-O worked!!!!!  Thanks so much.