SUM doesn't work anymore!!!

[Guest]

Hi guys

I have been pulling my hair out with this issue!!!

I have a form with a number of bound and unbound fields on it. I use the
SUM function via the field properties whilst in Design mode to set the
"Control Source" to =Sum([4 - t/pdk]). The name of the field that I want to
total is "4 - t/pdk". My problem is that the SUM function is working fine on
a number of the fields but is not working for the rest! There is no error
messages....it just does not display the value.

The Datatype for the fields that work and do not work is "Number", the
"Field Size" is double, the "Format" is "Standard" and the decimal places is
"0"

What am I doing wrong!!!

Help!

Regards
Greg

 

[Ken Snell \(MVP\)]

If you don't see an error display in the textbox, then it's likely that the
Sum value is Null, meaning that the values found for the [4 - t/pdk] field
are all Null. Check the data that your query or table is supplying to the
form for this field and verify that there are non-Null values for that
field.

 

[Guest]

Hi Ken,

[4 - t/pdk] does have a value in it but the value is calulated dynamically
using the "=[3 - kg/pdk]/1000"...perhaps this is why?

If this is the problem, do you have a solution?
Regards
Greg

If you don't see an error display in the textbox, then it's likely that the
Sum value is Null, meaning that the values found for the [4 - t/pdk] field
are all Null. Check the data that your query or table is supplying to the
form for this field and verify that there are non-Null values for that
field.
--

Ken Snell
<MS ACCESS MVP>

Hi guys

I have been pulling my hair out with this issue!!!

I have a form with a number of bound and unbound fields on it. I use the
SUM function via the field properties whilst in Design mode to set the
"Control Source" to =Sum([4 - t/pdk]). The name of the field that I want
to
total is "4 - t/pdk". My problem is that the SUM function is working fine
on
a number of the fields but is not working for the rest! There is no error
messages....it just does not display the value.

The Datatype for the fields that work and do not work is "Number", the
"Field Size" is double, the "Format" is "Standard" and the decimal places
is
"0"

What am I doing wrong!!!

Help!

Regards
Greg

 

[Ken Snell \(MVP\)]

Is [4 - t/pdk] a textbox on the form? If yes, Sum works only for fields, not
for controls. You must repeat the control expression that you're using for
the value of [4 - t/pdk] textbox:

=Sum([3 - kg/pdk]/1000)

--

Ken Snell
<MS ACCESS MVP>

Hi Ken,

[4 - t/pdk] does have a value in it but the value is calulated dynamically
using the "=[3 - kg/pdk]/1000"...perhaps this is why?

If this is the problem, do you have a solution?
Regards
Greg

If you don't see an error display in the textbox, then it's likely that
the
Sum value is Null, meaning that the values found for the [4 - t/pdk]
field
are all Null. Check the data that your query or table is supplying to the
form for this field and verify that there are non-Null values for that
field.
--

Ken Snell
<MS ACCESS MVP>

Hi guys

I have been pulling my hair out with this issue!!!

I have a form with a number of bound and unbound fields on it. I use
the
SUM function via the field properties whilst in Design mode to set the
"Control Source" to =Sum([4 - t/pdk]). The name of the field that I
want
to
total is "4 - t/pdk". My problem is that the SUM function is working
fine
on
a number of the fields but is not working for the rest! There is no
error
messages....it just does not display the value.

The Datatype for the fields that work and do not work is "Number", the
"Field Size" is double, the "Format" is "Standard" and the decimal
places
is
"0"

What am I doing wrong!!!

Help!

Regards
Greg

 

[Guest]

Hi Ken

I got it working!!!

Thanks for your help.

Regards
Greg

Is [4 - t/pdk] a textbox on the form? If yes, Sum works only for fields, not
for controls. You must repeat the control expression that you're using for
the value of [4 - t/pdk] textbox:

=Sum([3 - kg/pdk]/1000)

--

Ken Snell
<MS ACCESS MVP>

Hi Ken,

[4 - t/pdk] does have a value in it but the value is calulated dynamically
using the "=[3 - kg/pdk]/1000"...perhaps this is why?

If this is the problem, do you have a solution?
Regards
Greg

If you don't see an error display in the textbox, then it's likely that
the
Sum value is Null, meaning that the values found for the [4 - t/pdk]
field
are all Null. Check the data that your query or table is supplying to the
form for this field and verify that there are non-Null values for that
field.
--

Ken Snell
<MS ACCESS MVP>



Hi guys

I have been pulling my hair out with this issue!!!

I have a form with a number of bound and unbound fields on it. I use
the
SUM function via the field properties whilst in Design mode to set the
"Control Source" to =Sum([4 - t/pdk]). The name of the field that I
want
to
total is "4 - t/pdk". My problem is that the SUM function is working
fine
on
a number of the fields but is not working for the rest! There is no
error
messages....it just does not display the value.

The Datatype for the fields that work and do not work is "Number", the
"Field Size" is double, the "Format" is "Standard" and the decimal
places
is
"0"

What am I doing wrong!!!

Help!

Regards
Greg