Sum not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subform and at the botom of the form I have a field called subtotal
which is the sum of the extprice. I have just installed the database on a
system with Vista and Access 2007 on it and for some unknown reason the field
will not sum up the values in extprice

the control source is =sum(extprice)

I have installed the same database (in access 2000, Xp and 2003) onto the
new computer and the problem is the same, yet when I look at it on my
computer in Access 2007 everything appears fine,

anyone got any ideas

Thanks
 
Hi Nigel,

is ExtPrice a calculated field?

If so, try something like this:

ControlSource --> =Sum([Qty_control] * [price_control])

in other words, use the same equation in the Sum as you do in the
extended price :)


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
extprice works fine, its the sum(extprice) in the form footer that is not
working



strive4peace said:
Hi Nigel,

is ExtPrice a calculated field?

If so, try something like this:

ControlSource --> =Sum([Qty_control] * [price_control])

in other words, use the same equation in the Sum as you do in the
extended price :)


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*


I have a subform and at the botom of the form I have a field called subtotal
which is the sum of the extprice. I have just installed the database on a
system with Vista and Access 2007 on it and for some unknown reason the field
will not sum up the values in extprice

the control source is =sum(extprice)

I have installed the same database (in access 2000, Xp and 2003) onto the
new computer and the problem is the same, yet when I look at it on my
computer in Access 2007 everything appears fine,

anyone got any ideas

Thanks
Click to expand...
Click to expand...
 
Hi Nigel,

yes, I realize that ... but is extprice a calculated field? If so, you
need to use the equation in the Sum, not the control reference to extprice

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*


extprice works fine, its the sum(extprice) in the form footer that is not
working



strive4peace said:
Hi Nigel,

is ExtPrice a calculated field?

If so, try something like this:

ControlSource --> =Sum([Qty_control] * [price_control])

in other words, use the same equation in the Sum as you do in the
extended price :)


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*


I have a subform and at the botom of the form I have a field called subtotal
which is the sum of the extprice. I have just installed the database on a
system with Vista and Access 2007 on it and for some unknown reason the field
will not sum up the values in extprice

the control source is =sum(extprice)

I have installed the same database (in access 2000, Xp and 2003) onto the
new computer and the problem is the same, yet when I look at it on my
computer in Access 2007 everything appears fine,

anyone got any ideas

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Ext price is calculated using code, the strange thing is that it works on my
computer which has access 2007 but not on the other computer which also has
Access 2007.


strive4peace said:
Hi Nigel,

yes, I realize that ... but is extprice a calculated field? If so, you
need to use the equation in the Sum, not the control reference to extprice

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*


extprice works fine, its the sum(extprice) in the form footer that is not
working



strive4peace said:
Hi Nigel,

is ExtPrice a calculated field?

If so, try something like this:

ControlSource --> =Sum([Qty_control] * [price_control])

in other words, use the same equation in the Sum as you do in the
extended price :)


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



Nigel wrote:
I have a subform and at the botom of the form I have a field called subtotal
which is the sum of the extprice. I have just installed the database on a
system with Vista and Access 2007 on it and for some unknown reason the field
will not sum up the values in extprice

the control source is =sum(extprice)

I have installed the same database (in access 2000, Xp and 2003) onto the
new computer and the problem is the same, yet when I look at it on my
computer in Access 2007 everything appears fine,

anyone got any ideas

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Hi Nigel,

why are you calculating it with code instead of an equation in the
ControlSource?

don't know what to say on it working on one machine and not the other
except to ask if you have all the updates...

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*


Ext price is calculated using code, the strange thing is that it works on my
computer which has access 2007 but not on the other computer which also has
Access 2007.


strive4peace said:
Hi Nigel,

yes, I realize that ... but is extprice a calculated field? If so, you
need to use the equation in the Sum, not the control reference to extprice

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*


extprice works fine, its the sum(extprice) in the form footer that is not
working



:

Hi Nigel,

is ExtPrice a calculated field?

If so, try something like this:

ControlSource --> =Sum([Qty_control] * [price_control])

in other words, use the same equation in the Sum as you do in the
extended price :)


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



Nigel wrote:
I have a subform and at the botom of the form I have a field called subtotal
which is the sum of the extprice. I have just installed the database on a
system with Vista and Access 2007 on it and for some unknown reason the field
will not sum up the values in extprice

the control source is =sum(extprice)

I have installed the same database (in access 2000, Xp and 2003) onto the
new computer and the problem is the same, yet when I look at it on my
computer in Access 2007 everything appears fine,

anyone got any ideas

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top