Filter and Order of Records in Layout

[Jed69]

Hi All

I have a layout linked to a table for "To do" items. Each record has a due date field (in date format) and a done field (a simple yes tickbox). I would like the layout to only show items which are not done (ie do not have a tick in the yes box) and in Due Date order. I am using the List View for the form.

Is this possible?

John

[bcooney]

I would change your Done field to Completed and store the date (more meaningful).

Just Find records where Completed date is empty. (Enter Find mode and type "=" in the Complete field).

Sort records by Due Date ascending or descending.

[Jed69]

Ok I understand. Thank you