Hi All.
I have a query that is ordered to order the [Date Out] field in descending order. The [Date Out] field is the last to be completed on a record. So until a record (job in this case) is completed, the date out has a null value, which means it shows at the bottom of the records.
I have attempted to use conditional formatting to highlight a record when the date out field is null. However this is only effective when there are fewer than 4 records, as it is located on a subform which can only show limited records.
I was hoping for the date out with a null value to show at the top of the record list.
Does anybody have any idea on how this could be done?
Thanks
I have a query that is ordered to order the [Date Out] field in descending order. The [Date Out] field is the last to be completed on a record. So until a record (job in this case) is completed, the date out has a null value, which means it shows at the bottom of the records.
I have attempted to use conditional formatting to highlight a record when the date out field is null. However this is only effective when there are fewer than 4 records, as it is located on a subform which can only show limited records.
I was hoping for the date out with a null value to show at the top of the record list.
Does anybody have any idea on how this could be done?
Thanks