B Bee Registered User. Local time Today, 14:08 Joined Aug 1, 2006 Messages 486 Oct 4, 2006 #1 Hi, I have searched for this; however, I only found 'running sum'. Basically, I want to sum all records that have the same foreign key under one subtotal. Any suggestions will be very much appreciated.
Hi, I have searched for this; however, I only found 'running sum'. Basically, I want to sum all records that have the same foreign key under one subtotal. Any suggestions will be very much appreciated.
Matty ...the Myth Buster Local time Today, 08:08 Joined Jun 29, 2001 Messages 395 Oct 5, 2006 #2 Try setting a group in your report with the foreign key field and putting the sum in the group footer.
Try setting a group in your report with the foreign key field and putting the sum in the group footer.
B Bee Registered User. Local time Today, 14:08 Joined Aug 1, 2006 Messages 486 Oct 5, 2006 #3 Matty said: Try setting a group in your report with the foreign key field and putting the sum in the group footer. Click to expand... Great, cheers.
Matty said: Try setting a group in your report with the foreign key field and putting the sum in the group footer. Click to expand... Great, cheers.
