Can someone please tell me why my records aren't sorting in ascending order? 02/09/2005 appears after 02/16/2005.
Here is my SQL - the report is grouped by "Date Range" - each value - group interval 1.
SELECT [SchedDate] & " - " & [EventEnd] AS [Date Range], tblSchedule.StartTime, tblSchedule.EndTime, tblSchedule.Organization, tblSchedule.[Event Name], tblSchedule.PLead, tblSchedule.ELead, tblSchedule.Donations, tblSchedule.[Community Location], DatePart("m",[Scheddate]) & "/" & DatePart("yyyy",[Scheddate]) AS WhatMonth, DatePart("w",[Scheddate]) AS WhatDay, tblSchedule.SchedDate, tblSchedule.Advisor, tblSchedule.[Other Community]
FROM tblSchedule
WHERE (((tblSchedule.SchedDate) Between [enter Event start date] And [Enter event end date]))
ORDER BY [SchedDate] & " - " & [EventEnd], tblSchedule.Organization, DatePart("m",[Scheddate]) & "/" & DatePart("d",[Scheddate]) & "/" & DatePart("yyyy",[Scheddate]);
Thanks very much.
Here is my SQL - the report is grouped by "Date Range" - each value - group interval 1.
SELECT [SchedDate] & " - " & [EventEnd] AS [Date Range], tblSchedule.StartTime, tblSchedule.EndTime, tblSchedule.Organization, tblSchedule.[Event Name], tblSchedule.PLead, tblSchedule.ELead, tblSchedule.Donations, tblSchedule.[Community Location], DatePart("m",[Scheddate]) & "/" & DatePart("yyyy",[Scheddate]) AS WhatMonth, DatePart("w",[Scheddate]) AS WhatDay, tblSchedule.SchedDate, tblSchedule.Advisor, tblSchedule.[Other Community]
FROM tblSchedule
WHERE (((tblSchedule.SchedDate) Between [enter Event start date] And [Enter event end date]))
ORDER BY [SchedDate] & " - " & [EventEnd], tblSchedule.Organization, DatePart("m",[Scheddate]) & "/" & DatePart("d",[Scheddate]) & "/" & DatePart("yyyy",[Scheddate]);
Thanks very much.