I am fairly new to Access and am running into a slight problem. I have a form that has a drop down list where a user selects which lift station he wants. He also enters in how many hours that lift station was operating for that day. I have a query based on this Lift Station selection and a pump rate table. The query returns the pump rate for the selected Lift Station (see form.doc) form.doc
I want to take the result from the Query (Pump1Pumprate) and multiply it by Pump #1 Total Hours * 60 to get Pump #1 Volume. If I use the expression builder with my Query selected, I get the #Name? message in the Pump #1 Volume box (see expression.doc) expression.doc
I hope I have given enough info. What am I doing wrong?