By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

Sub Total

P: 25
hello ,

i ve 2 tables .
Table 1 has work order ; purchase order ( PK) .

Table 2 has purchase order ; equipments ; amount.

These 2 tables are linked , the link being purchase order.

Then i ve a form based on Table 1 and i ve inserted a text box on the form.

Now my query is , i need the total amount for all the equipments pertaining to each purchase order in that text book. Moreover the value should change depending upon work order no or purchase order no .

Could anyone please help me out here.

Sep 10 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,392
Set the control source of the text box to one of the D functions. I don't know exactly how you calculate your total but probably DLookup or DSum or a combination of them.
Sep 10 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.