Hello, I have a form that has 2 date fields on it, Date1 and Date2. These 2 fields are on the same row of the report and are tied to each other (just for internal purposes, not in the DB itself). The control is a query. Normally the fields are listed in ascending order by Date2. Sometimes there will be no value for Date2. If that's the case, I would like all the Date1 fields that don't have a Date2 value to reorder. This sounds really confusing the way I've explained it, so I attached a screenshot. Any help is appreciated!
sorting fields on a form based on other fields
- Thread starter Darla123
- Start date
