Combo Box to enter data to table

[oldgoldone]

I have a Combo Box with one colum that list septage holding & Grease, it enters the selection into the table field Waist type. Now say i want to do is run a reports based on Septage is there a way i can do this sence there is no field named septage

 

[PaulBricker]

How does the information appear in the Table? Is Grease somehow listed as a percentage of septage or is it just one lump value?

Paul

 

[oldgoldone]

I have to send 3 report to the D.E.P one saying how many gallons of septage one for Holding and one for Grease I have a field for gallons and a field for waist type so when i select grease in the combo it enters "Grease" into the waist type field

 

[PaulBricker]

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

 

[oldgoldone]

Thanks alot I will try it and get back to you