Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-15 : 02:05:55
|
Fadel writes "How can used the Orderby clause on the date to display ordering by month in the following crosstab query:
TRANSFORM Count(DT_PrimaryNotes.DiaryRef) AS [The Value]
SELECT ((Format(DateReceived,"mmm"))) AS Expr1, Count(DT_PrimaryNotes.DiaryRef) AS [Total Of DiaryRef]
FROM DT_PrimaryNotes
WHERE (((Format([DateReceived],"yyyy"))=Format(Now(),"yyyy")))
GROUP BY Format(DateReceived,"mmm")
PIVOT "[BilledActual]";" |
|
|
|
|
|
MS Access CrossTab Query