Recent content by miketonny

thx, but that doesn't solve the problem, i have 26 periods from 1 - 26,the reason i coded these in are i only wanted it to show the latest 6 periods. so next months a new period 27 comes in, i have to code 27 in the query, is there a better way of doing this?

I have a table i need to run reports on, so i need to run a cross tab query against it. I get to this far: TRANSFORM Sum(dbo_PSALES.PeriodSales) AS SumOfPeriodSales SELECT dbo_PSALES.UniqueID FROM dbo_PSALES GROUP BY dbo_PSALES.UniqueID PIVOT dbo_PSALES.PeriodNo In (26,25,24,23,22,21); Where...