After Empower I am making a concerted effort to spend more time in Web Access (Client). In doing so, I ran a quick search and wanted to do a primary sort by status and creation date. When I sort by status all is fine, but when I add the sort by creation date, I end up with the dates of the 10th and 13th intermingled. See screen shot.
I generated a report of this grouping to Excel and resorted there and found no issue, all the 10th dates were together as were all the 13th dates. No intermingling.
Please advise as to what may be occurring here, thanks!