Reply to thread

Message: [QUOTE="Guest, post: 6846485"] TRANSFORM Sum([subqry:BillableNonBillableDetailbyEmployee].SumOfWhours) AS SumOfSumOfWhours SELECT [subqry:BillableNonBillableDetailbyEmployee].ID, [subqry:BillableNonBillableDetailbyEmployee].Emplname, [subqry:BillableNonBillableDetailbyEmployee].DeptName, [subqry:BillableNonBillableDetailbyEmployee].Client, Sum([subqry:BillableNonBillableDetailbyEmployee].SumOfWhours) AS [Total Of SumOfWhours] FROM [subqry:BillableNonBillableDetailbyEmployee] GROUP BY [subqry:BillableNonBillableDetailbyEmployee].ID, [subqry:BillableNonBillableDetailbyEmployee].Emplname, [subqry:BillableNonBillableDetailbyEmployee].DeptName, [subqry:BillableNonBillableDetailbyEmployee].Client PIVOT Format([PriorYear],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"); Above is the SQL view of my crosstab query. I have a form where the begin and end dates are entered into a subquery. If the berinning date is entered as 07/01/04 and the end date is enteted as 06/30/05 tge qyeru shows the monts acress as Jan, Feb, etc. I would like to have the months appear as Jul 04, Aug 04, Sep 04...Jan 05...Jun 05. How do I do this? Thanks! Barb [/QUOTE]