Skip to Content
avatar image
Former Member

sales report by sub dept (UDF) with this year and last year comparitive

Hi guys Im really stuck on doing this query.....it keeps telling me my syntax is wrong and now my queries aren't running at all !

I need a query grouped by sub dept ( UDF) on OINM showing sales for this year and the same period for last year.

columns required are

Sub Dept (UDF), Item code, Qty, Sales value, Margin

hope someone can help.

thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers