Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Making selections in a report

Status
Not open for further replies.

mondeoman

MIS
Dec 7, 2006
203
GB
I have an invoice report which shows the time a job started, the time it finished the overall elapsed time. The work detail, start and finish time are drawn from a query based on a main table. The elapsed time is calculated from a hiden field that has calculated the minutes between start and finish. I want to have a field in the total column showing the overal cost based on the value of each minute. The minute value can vary depending on the type of job. When running the report the user has to put in the invoice number and company involved. How do I set up the report where, in addition, the user selects a minute value from a table (or original query)that is then calculated based on the overall time of the job?
 
When the user is entering the invoice number and company, he/she can also select the minute value based on your criteria in the same form.

Thanks for the help.
Greg
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top