If I understand you correctly, Septage is both Holding and Grease and then you need separate reports, one for Holding and one for Grease. The best way to do this is to create a query.
Click on the Query Tab. Select New and then select Simple Query Wizard. Click OK
In the next box under Tables/Queries look in the dropdown box for the table with your information.
Under Available Fields, add all the fields you want using the > arrow. Or add them all using the >> arrow. Click Next
Under What Title Do You Want For Your Query just put in the name that you want for it.
Under the two radio button, select Modify the Query Design.
This will open the query in Design View. On the Criteria line for your Waist Type (I think that should be Waste not Waist) put this criteria just the way I have it typed.
[Enter Waste Type] or [Enter Waste Type] Is Null
Save the changes to the query. When you open it, it will prompt you for Waste Type. You can enter Holding or Grease, or you can not enter anything and just click OK. If you do that, you will get all the records returned. If you enter a value, you will get just those records, Holding or Grease, returned.
Then create your Report from this query. When you open the report, you will get the same prompt for Waste Type. You can run the report 3 times. Once for all the records, once for just Holding and once for just Grease.
Give it a go, and post back with specific problems.
Good luck.
Paul
