tltanhueco1990
New member
- Local time
- Tomorrow, 00:47
- Joined
- Mar 15, 2023
- Messages
- 29
SELECT Year(#11/3/2023#) AS [Year], MonthName(1) AS [Month], Count(*) AS Total
FROM admissions
GROUP BY Month([admission_date])
The output is a blank query. Might I ask why the 'MonthName(Month(admission_date)), Month([admission_date])' part?
FROM admissions
GROUP BY Month([admission_date])
Oh fiddlesticks
SQL:SELECT Year([admission_date]) AS [Year], MonthName(Month([admission_date])) as [Month], Count(*) AS Total FROM admissions WHERE Year([admission_date]) = 2023 GROUP BY Year(admission_date), MonthName(Month(admission_date)), Month([admission_date]) ORDER BY Month(admission_date);
The output is a blank query. Might I ask why the 'MonthName(Month(admission_date)), Month([admission_date])' part?