I have one table that contains all my data. I can group into a result as below (the weight would the the sum per day):
03/03/2013 12:00 __________AP1 ________1.1
01/03/2013 10:00 __________AP2_________1.4
02/03/2013 10:00 __________AP2 ________1.1
03/03/2013 10:00 __________AP2_________1.1
How do I go about splitting the sum(weight) up into seperate columns based on 'Plant' so the query result looks like this:
Basically I want to group the results into columns rather than one long result.