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!

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

Updating a feild based on query

Status
Not open for further replies.
quinny1

quinny1

Programmer
Oct 17, 2000
12
GB
Hi Everyone,
I wonder if you can help. I have a form with a subform on it which contains several fields. The sub form is based on a table called "Works" which can have several records for each one record on the main form. The problem is I need several fields on the main form displaying the totals of all the associated records on the sub form.I.E. A field "TOTAL OF ACTUALS" on the main form would display the sum of the "ACTUAL" field related to the record on the main form. I tried assigning a query based on the table "WORKS" to the controlsource of a text box but can't get it to work. Could anyone help?

TIA

Quinny
 
Status
Not open for further replies.

Similar threads

lameid
  • Locked
  • Question
Execution Slowing on iterative generation of PDF's
Replies
3
Views
455
lameid
lameid
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
3K
Andrzejek
Andrzejek
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
569
renigar
renigar
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
2K
TheresAlwaysAWay
TheresAlwaysAWay
TheresAlwaysAWay
  • Locked
  • Question
Delete query takes FOREVER to run 1
Replies
11
Views
331
jedraw
jedraw

Part and Inventory Search

Sponsor

Back
Top