Calculations on a Report Form

[Guest]

I am creating a report and have created a text box to total hours spent on
the job.
Several of the calculations are coming from a table other than the one on
the report. I successfull create the calculation, but when I open the report
I get the parameter box. How can I prevent this? Thanks....

 

[Guest]

Are any of the values you're using in your calculation coming from a query,
or are they strictly from the table. A typical common error is to have the
data come from a query that isn't open (in which case you can use a macro to
open the query and then suppress it). If it's not coming from a query, some
idea of your table structure and formula might help to better diagnose the
problem.

- JK

 

[Guest]

Thanks,

All values are in a table. Basically, it is a persons name, and then hours
worked on site. one text field and the onsite hours are broken out into
several numeric fields.

 

[Guest]

Dirk ...

You are getting the prompt because as you stated below "Several of the
calculations are comming from a table other than the one on the report."
Sounds like the fields are not in the RecordSource for the report.

Solution:

Create a Select Query that includes all the necessary tables needed to build
the report. Make this query the RecordSource for the report rather than a
single table.

ET