Setting Search results order.
I have a search form that works wonderfully but it won't order by date.
I have set the Recordset to order by date:
SELECT *
FROM joborders
WHERE joborders.JOStatus = 'Open'
ORDER BY joborders.JOClosingDate ASC
But it still will not sort by date in the results. Doesn't appear to be any pattern that it does order by - seems very random.
Any ideas?