Display Report Total in Form

W

WorkRelated

Im I able to display the total from a report in a field of a form. Database
as below

Purchase Order Database
Main Table/Form
- OrderID (autonumber)
- Job Ref
SubForm
- OrderID
- Quantity
- Price

I have a query which asks for the job ref then totals each order I then have
a report that sums all the totals of each order to give a final total.

I have linked this database to another one and imported the above query and
report

Job Costing Database
Main Table/Form
-Job Ref
-Total Purchases

I would like the database to automaticaly enter the total of the report in
the 'Total Purchases' field of the form that has the same job ref as the
report
 
A

Arvin Meyer [MVP]

Reports are static and the data cannot be read from a form. You can,
however, use the same technique on the form footer to calculated the values
from that form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

importing 3
Access Inventory Calculation 0
MS ACCESS INVENTORY CALCULATION 0
Display total value on subform 1
conditonal sum? 0
Summing groups in a report 1
report 1
Total value of invoices created per job 5

Top