In a query I have a field
That field is referenced in a cross tab query
When I try and order Days they are not in order WHEN 'Days' is clearly expressed as an Integer in the original query
Why is this happening?
Code:
Days: Int(IIf(tbl_Data!DaysRequestToProcedure1<0,"0",IIf(tbl_Data!DaysRequestToProcedure1>=12,"12",tbl_Data!DaysRequestToProcedure1)))That field is referenced in a cross tab query
Code:
PARAMETERS [Forms]![frmRptDialogSingle]![begdate] DateTime, [Forms]![frmRptDialogSingle]![enddate] DateTime;
SELECT qry_cardiology1.Days, Count(qry_cardiology1.EpisodeID) AS CountOfEpisodeID, RunSum([CountOfEpisodeID]) AS RunTotal
FROM qry_cardiology1
WHERE (((qry_cardiology1.RequestDatetime) Between [Forms]![frmRptDialogSingle]![begdate] And [Forms]![frmRptDialogSingle]![enddate]))
GROUP BY qry_cardiology1.Days;When I try and order Days they are not in order WHEN 'Days' is clearly expressed as an Integer in the original query
Why is this happening?
