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********@hotmail.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.