subform sort order

[kronar30]

After User enters a new record, I do a form requery using this code. But records always display in ascending order. Even when I take the DESC out.


qrycall = ChangeQueryDef("UpdateTimeQuerybyDate", "select * from [JBT_EmpTime] where JBT_Date = #" & hldDate & "# and JB_JobBidNo = '" & hldJobNum & "' order by JBT_Date DESC")

[TimebyDate].Form.Requery

How can I make it display in reverse order??
Thanks for all the help

 

[dhookom]

I don't understand why you are filtering to a single value in a field and then sorting by the same single value in a field.

Duane
Hook'D on Access
MS Access MVP

 

[lionelhill]

That may be the answer. If the query was intended to list by descending order of Time-of-Day, filtered to a single day, then it won't return anything at all unless JBT_Date and hldDate have been trimmed down to integers, in which case there is no time-of-day information for the Order By to use... In which case the records will be returned in whatever order Access feels like using.