mkl-si
asked on
selective sorting and/or filtering records for a report
I have a report that sorts records in an ascending list based on a date field value. I would like to omit some of the records from the report if the value in another text field (status) is equal to "completed" [conversely, I want the report to display all records where "status" does not equal "complete"].
Thanks!
Thanks!
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Obviously you can set "All" as the value that appears in the combobox when the form first opens...
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
You can change the underlying recordset.
If the underlying query is
SELECT * from tblSomeTable;
then you can change it to
SELECT * from tblSomeTable where Status <> "Complete";
If you want to change it temporarily, or upon some condition, the in the Report_Open event of the report put
Me.Filter = "Status <> ""Complete""
Me.FliterOn = true