sum lookup

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
 
C

Crystal (strive4peace)

A

Ashley

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...
 
C

Crystal (strive4peace)

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form Refresh 1
need help with an UPDATE statement 1
Sum() 5
Summing a complex formula 1
Using DSUM to get running total on a filtered form 0
Sum By Date in Access 2002 Form Footer 2
#Error when summing in Form 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1

Top