Lets say I have the following data:
Description Status Date Complete No.
One Open 1/23 No 4
Two Closed 1/23 Yes 5
Three Open 12/2 No 1
Four Open 1/3 No 2
First, I only want to display records that are not complete (value in complete column is 'no'). Then I want to sort results by date (ascending), then no(ascending).
I know how to do the sorting and groupings. But how do I set up a filter so that my 'Detail' section of the design view of a report only desiplays records for which a certain field has a specifc value. In this case, i only want to display records that are 'completed'
Someone please help!
Description Status Date Complete No.
One Open 1/23 No 4
Two Closed 1/23 Yes 5
Three Open 12/2 No 1
Four Open 1/3 No 2
First, I only want to display records that are not complete (value in complete column is 'no'). Then I want to sort results by date (ascending), then no(ascending).
I know how to do the sorting and groupings. But how do I set up a filter so that my 'Detail' section of the design view of a report only desiplays records for which a certain field has a specifc value. In this case, i only want to display records that are 'completed'
Someone please help!
