I've created a number of databases for my personal use over the past three decades, mostly in mdb format, some converted to accdb as needed. The one I'm currently creating is the first one that's accdb from the start and I'm seeing some behavior I've never seen before.
When designing a query and setting a sort order on a field, a duplicate column gets created at the right end of the grid so that I have one column with the sort showing and one without. Something like this:
The query still works, but it gets really confusing when I'm designing multi-column sorts.Code:-------------------------------------------------- | DateDue | PriorityID | DateDue | PriorityID | | tblTasks | tblTasks | tblTasks | tblTasks | | | | Ascending | Ascending | --------------------------------------------------
Is this some new behavior in v.2010 (my newest version... yeah, I know, I'm way behind)? Is there a setting somewhere that I can change to make it stop doing this?