Unanswered: Organize data by years and dept, please help, thanks
I have a database with three queries of data named 2008,2009,2010. They are organized by varies department number. Is there anyway I can create a query with dept number sorted and different years data in different columns? like 1st column dept #, 2 column 2008 data associated with that dept #, etc? what is the sql for this thanks alot.