sum lookup

  • Thread starter Thread starter Ashley
  • Start date Start date
A

Ashley

The control source of MINUTES is =[PRICINGID].Column(4)
In form footer, I have =sum([minutes]). But it is not working. It is blank.
Can someone please help!
Thanks
 
Hi Crystal,
I tried =sum([PRICINGID].[Column](4)) and got #Error
What is wrong with the formula?
Thanks

Crystal (strive4peace) said:
Hi Ashley,

if you want to sum a control that is based on an equation,
you need to sum the equation ... but you also cannot sum a
column of a combobox. You can only sum fields from the
RecordSource.


Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
(: have an awesome day :)
*

The control source of MINUTES is =[PRICINGID].Column(4)
In form footer, I have =sum([minutes]). But it is not working. It is blank.
Can someone please help!
Thanks
Click to expand...
.
Click to expand...
 
Hi Ashley,

"you also cannot sum a column of a combobox. You can only
sum fields from the RecordSource."


Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
(: have an awesome day :)
*

Hi Crystal,
I tried =sum([PRICINGID].[Column](4)) and got #Error
What is wrong with the formula?
Thanks

Crystal (strive4peace) said:
Hi Ashley,

if you want to sum a control that is based on an equation,
you need to sum the equation ... but you also cannot sum a
column of a combobox. You can only sum fields from the
RecordSource.


Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
(: have an awesome day :)
*

The control source of MINUTES is =[PRICINGID].Column(4)
In form footer, I have =sum([minutes]). But it is not working. It is blank.
Can someone please help!
Thanks
Click to expand...
.
Click to expand...
Click to expand...
 
Back
Top