Can this be done?
i have a form in which i enter new jobs. these job no's have corresponding tasks, and each of these can be ticked completed, invoiced etc. one of the fields though is an actual cost. now for me to get the actual cost i have to run another report i have(Job Actuals) to get the amount that task cost. Is it possible to get the query that runs my job actuals report, to spit out the result into a text box next to the corresponding task on my NewJobs Form? obviously i would need to replicate the report and rename it so i dont disturb the Job Actuals Report.
Any help would be greatly appreciated!
Thankyou
i have a form in which i enter new jobs. these job no's have corresponding tasks, and each of these can be ticked completed, invoiced etc. one of the fields though is an actual cost. now for me to get the actual cost i have to run another report i have(Job Actuals) to get the amount that task cost. Is it possible to get the query that runs my job actuals report, to spit out the result into a text box next to the corresponding task on my NewJobs Form? obviously i would need to replicate the report and rename it so i dont disturb the Job Actuals Report.
Any help would be greatly appreciated!
Thankyou