Recordsets not sorted correctly in DA
Hi, inside a DA created page, one of my recordsets doesn't sort correctly. I have it set to 'ORDER BY tblcases.CaseID Desc' in query manager and if tested in there it shows correctly. If I then view in page it does 'ORDER BY tblcases.CaseID Asc',
I do have 2 other recordsets in the page but I dont think they are affecting this one, they simply provide data for menus created by DA wizard..
Any ideas where I am going wrong, the page is attached..