What I'm about may make no sense hard to comprehend, but I have a qry with 2-flds that are have the same data (WkDys -- days of the week). The first fld is 'DUP'' & the second fld is called, DUP_SA'. I also have a 'WDyNum' tbl with the WkDys starting with Sun (1) to Sat (7). I don't know how I can sot the 'DUP_SA' according to WkDyNum sorting order.
Any advice/suggestions will be greatly appreciated! Thanks in advanced!