E
elena
Hi, All
i have a query (all credits to Chis2)
TRANSFORM Nz(COUNT(TempTicks.Tick),0) AS CountOfTick
SELECT TempTicks.Badge
FROM TempTicks
GROUP BY TempTicks.Badge
PIVOT fWeekdayName(DatePart("w",TempTicks.IssDate)) & " " & TempTicks.IssDate;
the output looks like this:
Badge, Friday 06/22/2007, Monday 06/18/2007, Tuesday 06/19/2007
999, 1, 1, 1
Question: Is it possible to have output fields in ASC order?
Thank you, for your help
i have a query (all credits to Chis2)
TRANSFORM Nz(COUNT(TempTicks.Tick),0) AS CountOfTick
SELECT TempTicks.Badge
FROM TempTicks
GROUP BY TempTicks.Badge
PIVOT fWeekdayName(DatePart("w",TempTicks.IssDate)) & " " & TempTicks.IssDate;
the output looks like this:
Badge, Friday 06/22/2007, Monday 06/18/2007, Tuesday 06/19/2007
999, 1, 1, 1
Question: Is it possible to have output fields in ASC order?
Thank you, for your help