Help with Sum function!

[John Baker]

Hi:

I have a field on a form that is names 125POP. It is currency.

I can refer perfectly well to it in a text box when I want to add it to something as in:
=[125POP]+[Payroll]

HOWEVER

when i want to sum it, I have a problem.

=sum ([125POP]) produces an error, not only in the field involved but also all to her sum
fields on the form.

I have no idea what the issue is, but would love to get some pointers so I can sort it
out!

Thanks

John Baker

[pietlinden]

John Baker wrote:

Hi:

I have a field on a form that is names 125POP. It is currency.

I can refer perfectly well to it in a text box when I want to add it to something as in: =[125POP]+[Payroll]

HOWEVER

when i want to sum it, I have a problem.

=sum ([125POP]) produces an error, not only in the field involved but also all to her sum fields on the form.

I have no idea what the issue is, but would love to get some pointers so I can sort it out!

are you trying to sum a single field across records (by using SUM), or
are you trying to just add up values on a form? If you're trying to
add values in controls on your form, it's like this:

=[Field]+[Field2]+[Field3]

If you're trying to add up a column (separate records) as you would a
column in Excel, then you need to use either DSUM or use a query.

[John Baker]

I am trying to add a single field across records on the form ( its for payroll). The SUM
wotrks fine for some other fields in the same records, but there is something weird about
the 125POP field and I cant get my hands around it!.
pi********@hotm ail.com wrote:

John Baker wrote:

Hi:

I have a field on a form that is names 125POP. It is currency.

I can refer perfectly well to it in a text box when I want to add it

to something as in:

=[125POP]+[Payroll]

HOWEVER

when i want to sum it, I have a problem.

=sum ([125POP]) produces an error, not only in the field involved but

also all to her sum

fields on the form.

I have no idea what the issue is, but would love to get some pointers

so I can sort it

out!

are you trying to sum a single field across records (by using SUM), or
are you trying to just add up values on a form? If you're trying to
add values in controls on your form, it's like this:

=[Field]+[Field2]+[Field3]

If you're trying to add up a column (separate records) as you would a
column in Excel, then you need to use either DSUM or use a query.

[Mike Watson]

Hi John Baker,

Piet Linden is on the right track. I would add that the problem appears
to be because you probably have the form field 125POP bound to the
table/query field with the same name, 125POP. Try calling the form
field 'txt125POP' (bound to 125POP). Modify the other form fields'
references to this new name. For example,

=[txt125POP]+[Payroll]

The form fields that use the Sum function should refer to the
table/query fields and should remain:

=Sum([125POP])

Cheers,

Mike Watson
Connecting Software
via Lodovico il Moro 87
20143 Milano, Italy

John Baker wrote:

I am trying to add a single field across records on the form ( its for payroll). The SUM wotrks fine for some other fields in the same records, but there is something weird about the 125POP field and I cant get my hands around it!.
pi********@hotm ail.com wrote:

John Baker wrote:

Hi:

I have a field on a form that is names 125POP. It is currency.

I can refer perfectly well to it in a text box when I want to add

itto something as in:

=[125POP]+[Payroll]

HOWEVER

when i want to sum it, I have a problem.

=sum ([125POP]) produces an error, not only in the field involved

butalso all to her sum

fields on the form.

I have no idea what the issue is, but would love to get some

pointersso I can sort it

out!

are you trying to sum a single field across records (by using SUM), orare you trying to just add up values on a form? If you're trying to
add values in controls on your form, it's like this:

=[Field]+[Field2]+[Field3]

If you're trying to add up a column (separate records) as you would acolumn in Excel, then you need to use either DSUM or use a query.