H hmho Registered User. Local time Today, 03:28 Joined Apr 7, 2009 Messages 93 Apr 9, 2009 #1 Hi. I created report based on sub query but when I put formula in the footer for subtotal I'm getting error.
Hi. I created report based on sub query but when I put formula in the footer for subtotal I'm getting error.
pbaldy Wino Moderator Staff member Local time Today, 03:28 Joined Aug 30, 2003 Messages 36,272 Apr 9, 2009 #2 Make sure it's in the report footer rather than the page footer.
H hmho Registered User. Local time Today, 03:28 Joined Apr 7, 2009 Messages 93 Apr 9, 2009 #3 I did still getting error. The field name is [AmountSold] and I put the formula in the footer as =sum([AmountSold]). Please help. thanks
I did still getting error. The field name is [AmountSold] and I put the formula in the footer as =sum([AmountSold]). Please help. thanks
pbaldy Wino Moderator Staff member Local time Today, 03:28 Joined Aug 30, 2003 Messages 36,272 Apr 9, 2009 #4 Also make sure you don't have a control with the same name as the field. Since it looks like the field in your query/table is called AmountSold, make sure you don't have a textbox with the same name. If AmountSold is a calculated field: http://support.microsoft.com/kb/207763
Also make sure you don't have a control with the same name as the field. Since it looks like the field in your query/table is called AmountSold, make sure you don't have a textbox with the same name. If AmountSold is a calculated field: http://support.microsoft.com/kb/207763