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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to get the sum of the detailed block

Status
Not open for further replies.

tyb

Technical User
Feb 10, 2004
137
IR
Dear Frends

i'v a quantity colum in the detailed block as well in the master block. now i want the master block quantity to be updated with the sum of all the detail block quantities on each insertion or updation in the detail block.

plz help me.

thanx
 
Assuming you are using at least forms 6, use a summary column.
 
Unfortunately I think you have to do it manually, because summary column can not belong to master block. Though you may use lewisp's advice if it's possible to copy that value from detail block.

Regards, Dima
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top