Hello All -
We need help to devise a query that compares 2009 and 2010 sales for each BP.
Columns of info we would like are Acct #...Foreign Name...Sales Rep...Company...Bill To Address...Bill To City...Bill To Zip...Bill To Phone...Contact...Jan 09 Sales...Feb 09 Sales...etc. for all 12 months in 2009 AND all 12 months in 2010. Not sure if this is too long to display.
Also, would need to include returns / credit memos.
Thanks very much!
Mike