Need to input number for calculation

[paulhh]

Rewrote as solved part of it...

We have a report that can be run between two input dates.
Query gives data by customer by employee by manager
Report summarizes data by employee by manager by total shop

1. Need query to ask Forecast hours for each of 10 employees and 3 managers (Managers totals may not reflect totals of their individual employees) and then in report have column with percent based on
actual hours/ forecast hours

Since these don't affect the query output only the format on the report do I need the query to ask those questions or can they be asked at report time instead?

Just to get shop total I tried adding three fields to ask the Mgr hrs but when I tried adding them together for my divisor it concatinated them as text rather than adding them as numbers even when I set them as "Standard"

2. How can I add a text field - manager name and an input field "Forecast hours" together for report output?

Appreciate your response.

 

[Travis]

Use a FORM to ask the Questions and the report to Read the Answers.

By creating an input form you can save the user the agrevation of having to answer to questions more then once. Launch the Report from this form.