Hi all, this probably an easy request, but I’ve been scratching my head for a few hours to sort this little problem I have. Below is a scaled down output from my query, I’d like to be able to plot a line graph in a report, that would show Y axis as “CountOfQTY” and X axis “Posting date” , but in the format of Month year. So for Jan 07 my graph would show a QTY of 13 and Feb 07 would show QTY of 5 etc.. Could someone please advise me the best way to do this. Thanks
Part PostingDate CountOfQTY
Widget 18/01/2007 6
Widget 25/01/2007 7
Widget 12/02/2007 1
Widget 15/02/2007 1
Widget 26/02/2007 3
Widget 11/06/2007 4
Widget 19/06/2007 1
Widget 20/06/2007 1
Widget 03/07/2007 6
Widget 04/07/2007 3
Widget 11/07/2007 1
Widget 19/07/2007 5
Widget 23/07/2007 1
Widget 24/07/2007 4
Widget 02/08/2007 5
Widget 13/08/2007 2
Widget 14/08/2007 2
Widget 16/08/2007 4
Widget 21/08/2007 5
Widget 28/08/2007 1
Widget 31/08/2007 5
Widget 11/09/2007 10
Part PostingDate CountOfQTY
Widget 18/01/2007 6
Widget 25/01/2007 7
Widget 12/02/2007 1
Widget 15/02/2007 1
Widget 26/02/2007 3
Widget 11/06/2007 4
Widget 19/06/2007 1
Widget 20/06/2007 1
Widget 03/07/2007 6
Widget 04/07/2007 3
Widget 11/07/2007 1
Widget 19/07/2007 5
Widget 23/07/2007 1
Widget 24/07/2007 4
Widget 02/08/2007 5
Widget 13/08/2007 2
Widget 14/08/2007 2
Widget 16/08/2007 4
Widget 21/08/2007 5
Widget 28/08/2007 1
Widget 31/08/2007 5
Widget 11/09/2007 10