M Miller84 Registered User. Local time Today, 15:33 Joined Nov 18, 2004 Messages 18 Dec 1, 2004 #1 How do I add up say RentalCost of 3 items in one order so that it appears in the main form as a subtotal. Is it use of the SUM function or is it more complex? Thanks
How do I add up say RentalCost of 3 items in one order so that it appears in the main form as a subtotal. Is it use of the SUM function or is it more complex? Thanks
S SunWuKung Registered User. Local time Today, 23:33 Joined Jun 21, 2001 Messages 172 Dec 1, 2004 #2 Well, I would just run a separate query to calculate sum. The other thing that comes to my mind is working with the recordset of the subform. A nicely packed version of this is on http://support.microsoft.com/default.aspx?scid=kb;en-us;Q210338 hth SWK
Well, I would just run a separate query to calculate sum. The other thing that comes to my mind is working with the recordset of the subform. A nicely packed version of this is on http://support.microsoft.com/default.aspx?scid=kb;en-us;Q210338 hth SWK
P Pat Hartman Super Moderator Staff member Local time Today, 18:33 Joined Feb 19, 2002 Messages 47,070 Dec 2, 2004 #3 Just add a footer to the subform and place the =Sum(somefield) there.
S SunWuKung Registered User. Local time Today, 23:33 Joined Jun 21, 2001 Messages 172 Dec 2, 2004 #4 Ye, there is always a bigger fish. I knew that there should be a control based solution but I couldn't tell what that would be....
Ye, there is always a bigger fish. I knew that there should be a control based solution but I couldn't tell what that would be....
M Miller84 Registered User. Local time Today, 15:33 Joined Nov 18, 2004 Messages 18 Dec 2, 2004 #5 Cheers! Got that to work with a bit of time.
