Caluclated Field

[Guest]

OK, I have yet another stupid question...

I have a form (PurchaseOrders) with a subform (ItemsOrdered). I want to have
a field on the form that totals the data from the subform. I have looked at
questions that other people have posted and the common answer to this problem
seems to be a text box in the form footer with a control source of
=Sum([Forms]![ItemsOrdered subform]![ItemTotal]), but then it just says
#Name?. I have checked and rechecked the field names, so I know they are
correct. What am I doing wrong?

 

[Guest]

In the subform footer create a field, not visible and create the sum there
=Sum([FieldName])

In the Main form, refer to this field
=[SubFormName].Form.[SumFieldName]

 

[Guest]

I must be slower than I previously thought, I tried that, the field says
$0.00, but does not update when I enter in data.

In the subform footer create a field, not visible and create the sum there
=Sum([FieldName])

In the Main form, refer to this field
=[SubFormName].Form.[SumFieldName]

--
\\// Live Long and Prosper \\//
BS"D

OK, I have yet another stupid question...

I have a form (PurchaseOrders) with a subform (ItemsOrdered). I want to have
a field on the form that totals the data from the subform. I have looked at
questions that other people have posted and the common answer to this problem
seems to be a text box in the form footer with a control source of
=Sum([Forms]![ItemsOrdered subform]![ItemTotal]), but then it just says
#Name?. I have checked and rechecked the field names, so I know they are
correct. What am I doing wrong?

 

[Guest]

It should update when you move to the next record in the sub form, after you
update the record in the sub form

--
\\// Live Long and Prosper \\//
BS"D

I must be slower than I previously thought, I tried that, the field says
$0.00, but does not update when I enter in data.

In the subform footer create a field, not visible and create the sum there
=Sum([FieldName])

In the Main form, refer to this field
=[SubFormName].Form.[SumFieldName]

--
\\// Live Long and Prosper \\//
BS"D

OK, I have yet another stupid question...

I have a form (PurchaseOrders) with a subform (ItemsOrdered). I want to have
a field on the form that totals the data from the subform. I have looked at
questions that other people have posted and the common answer to this problem
seems to be a text box in the form footer with a control source of
=Sum([Forms]![ItemsOrdered subform]![ItemTotal]), but then it just says
#Name?. I have checked and rechecked the field names, so I know they are
correct. What am I doing wrong?

 

[Guest]

Even when I go to the next record in the subform, in the main form...No
matter what I do it stays at $0.00.

It should update when you move to the next record in the sub form, after you
update the record in the sub form

--
\\// Live Long and Prosper \\//
BS"D

I must be slower than I previously thought, I tried that, the field says
$0.00, but does not update when I enter in data.

In the subform footer create a field, not visible and create the sum there
=Sum([FieldName])

In the Main form, refer to this field
=[SubFormName].Form.[SumFieldName]

--
\\// Live Long and Prosper \\//
BS"D


:

OK, I have yet another stupid question...

I have a form (PurchaseOrders) with a subform (ItemsOrdered). I want to have
a field on the form that totals the data from the subform. I have looked at
questions that other people have posted and the common answer to this problem
seems to be a text box in the form footer with a control source of
=Sum([Forms]![ItemsOrdered subform]![ItemTotal]), but then it just says
#Name?. I have checked and rechecked the field names, so I know they are
correct. What am I doing wrong?

 

[Guest]

Check if the problem is with the sum field or with the field in the mainform

While the form is open, open the Immidiate window (Ctrl+G) and type
?Forms![MainFormName]![SubFormName].Form![SumFieldName]

press enter and see what value is returned, if it return 0, check the Sum
field again.

One more question, are there field with Null, if you have add that to the
sum field
=Sum(Nz([FieldName],0))
--
\\// Live Long and Prosper \\//
BS"D

Even when I go to the next record in the subform, in the main form...No
matter what I do it stays at $0.00.

It should update when you move to the next record in the sub form, after you
update the record in the sub form

--
\\// Live Long and Prosper \\//
BS"D

I must be slower than I previously thought, I tried that, the field says
$0.00, but does not update when I enter in data.

:

In the subform footer create a field, not visible and create the sum there
=Sum([FieldName])

In the Main form, refer to this field
=[SubFormName].Form.[SumFieldName]

--
\\// Live Long and Prosper \\//
BS"D


:

OK, I have yet another stupid question...

I have a form (PurchaseOrders) with a subform (ItemsOrdered). I want to have
a field on the form that totals the data from the subform. I have looked at
questions that other people have posted and the common answer to this problem
seems to be a text box in the form footer with a control source of
=Sum([Forms]![ItemsOrdered subform]![ItemTotal]), but then it just says
#Name?. I have checked and rechecked the field names, so I know they are
correct. What am I doing wrong?

 

[Guest]

OK, when I checked the formula in the main form, the value returned is Null.
When checked in the subform, it was 0. I know the field names are correct, I
don't have any null fields, but I tried =Sum(Nz([FieldName],0)) too and
still, $0.00 know matter what.

Does it make a difference what version of Access I am using, if it does, I
have '97.

Check if the problem is with the sum field or with the field in the mainform

While the form is open, open the Immidiate window (Ctrl+G) and type
?Forms![MainFormName]![SubFormName].Form![SumFieldName]

press enter and see what value is returned, if it return 0, check the Sum
field again.

One more question, are there field with Null, if you have add that to the
sum field
=Sum(Nz([FieldName],0))
--
\\// Live Long and Prosper \\//
BS"D

Even when I go to the next record in the subform, in the main form...No
matter what I do it stays at $0.00.

It should update when you move to the next record in the sub form, after you
update the record in the sub form

--
\\// Live Long and Prosper \\//
BS"D


:

I must be slower than I previously thought, I tried that, the field says
$0.00, but does not update when I enter in data.

:

In the subform footer create a field, not visible and create the sum there
=Sum([FieldName])

In the Main form, refer to this field
=[SubFormName].Form.[SumFieldName]

--
\\// Live Long and Prosper \\//
BS"D


:

OK, I have yet another stupid question...

I have a form (PurchaseOrders) with a subform (ItemsOrdered). I want to have
a field on the form that totals the data from the subform. I have looked at
questions that other people have posted and the common answer to this problem
seems to be a text box in the form footer with a control source of
=Sum([Forms]![ItemsOrdered subform]![ItemTotal]), but then it just says
#Name?. I have checked and rechecked the field names, so I know they are
correct. What am I doing wrong?

 

[Guest]

OK, I have achieved a small victory. I got the SUM field in the subform to
work (using a query that I still don't actually understand) I then referenced
the same field from the subform in a textbox in the main form, but it is
blank, no #Name?, no Error or anything, blank.

Check if the problem is with the sum field or with the field in the mainform

While the form is open, open the Immidiate window (Ctrl+G) and type
?Forms![MainFormName]![SubFormName].Form![SumFieldName]

press enter and see what value is returned, if it return 0, check the Sum
field again.

One more question, are there field with Null, if you have add that to the
sum field
=Sum(Nz([FieldName],0))
--
\\// Live Long and Prosper \\//
BS"D

Even when I go to the next record in the subform, in the main form...No
matter what I do it stays at $0.00.

It should update when you move to the next record in the sub form, after you
update the record in the sub form

--
\\// Live Long and Prosper \\//
BS"D


:

I must be slower than I previously thought, I tried that, the field says
$0.00, but does not update when I enter in data.

:

In the subform footer create a field, not visible and create the sum there
=Sum([FieldName])

In the Main form, refer to this field
=[SubFormName].Form.[SumFieldName]

--
\\// Live Long and Prosper \\//
BS"D


:

OK, I have yet another stupid question...

I have a form (PurchaseOrders) with a subform (ItemsOrdered). I want to have
a field on the form that totals the data from the subform. I have looked at
questions that other people have posted and the common answer to this problem
seems to be a text box in the form footer with a control source of
=Sum([Forms]![ItemsOrdered subform]![ItemTotal]), but then it just says
#Name?. I have checked and rechecked the field names, so I know they are
correct. What am I doing wrong?