Calculations based on text box

[bill]

I have written a query that pulls data from a table based
on input from the user in one of 5 text boxes on a form.
The user can provide information in all 5 text boxes if
necessary. I now need to sum the information in the
query based on the 5 inputs on a report.

An example in english terms would be:

Sum(Var1) for textbox input1
Sum(Var1) for textbox input2
Sum(Var1) for textbox input3
etc.

Does anyone know the syntax to use in the control source
of the text box on the report?

Thanks in advance
Bill

 

[Jennifer H.]

Not quite sure what final data you want, but whatever it
is, you can create a query that generates the final data,
then set the recordsource for the report to that query.
At run time, you can use the Open event to set the
report's recordsource to an existing query or to a SQL
string. Hope this helps. j.