Sum on footer returns #Name

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

Guest

Hi,

First my apologies - I posted a question similar to this a couple of weeks
back, subsequently got sidetracked with other tasks and couldn't get back to
this problem until now. Hence the repost of my old question.

I have a form based on a query; on the form in the detail section is a
calculated control =[PACE_SUMM_HEDGE]/1000000+[Hedge_adj]-[Hedge_val]. Note:
the fields [PACE_SUMM_HEDGE] & [Hedge_adj] are from the query while
[Hedge_val] is the name of another calculated control (also in the detail
section). I have named this control "Hedges". This works fine.

I would like to sum this calculation in the footer section; my calculated
control has the formula =sum([Hedges]). This does NOT work - it returns
#Name?

As does the formula =Sum([PACE_SUMM_HEDGE]/1000000+[Hedge_adj]-[Hedge_val]).

As does the formula
=Sum([PACE_SUMM_HEDGE]/1000000+[Hedge_adj]-IIf([Forms]![Adjustments
Page]![Type Combo].[Value]="Hedges",[Forms]![Adjustments
Page]![Amount].[Value]*[Allocation]/100,0)).

I realize this last formula is messy - all the fields in this last formula
are from the query or another form that is open.

Any help? Why am I getting #Name? for each of these formulas?

Thanks
 
Thanks for the suggestion - no luck though.

In an attempt to simplify things on the form (hoping that might solve the
problem), I have changed the query so that I do not reference another
calculated control in any other control. In the detail section I now have
[Hedges] as the control formula - which works - and =sum([Hedges]) in the
footer - which does not work.


Lynn Trapp said:
Try putting Sum(=[PACE_SUMM_HEDGE]/1000000+[Hedge_adj]-[Hedge_val]) in the
control instead.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html



kabaka said:
Hi,

First my apologies - I posted a question similar to this a couple of weeks
back, subsequently got sidetracked with other tasks and couldn't get back
to
this problem until now. Hence the repost of my old question.

I have a form based on a query; on the form in the detail section is a
calculated control =[PACE_SUMM_HEDGE]/1000000+[Hedge_adj]-[Hedge_val].
Note:
the fields [PACE_SUMM_HEDGE] & [Hedge_adj] are from the query while
[Hedge_val] is the name of another calculated control (also in the detail
section). I have named this control "Hedges". This works fine.

I would like to sum this calculation in the footer section; my calculated
control has the formula =sum([Hedges]). This does NOT work - it returns
#Name?

As does the formula
=Sum([PACE_SUMM_HEDGE]/1000000+[Hedge_adj]-[Hedge_val]).

As does the formula
=Sum([PACE_SUMM_HEDGE]/1000000+[Hedge_adj]-IIf([Forms]![Adjustments
Page]![Type Combo].[Value]="Hedges",[Forms]![Adjustments
Page]![Amount].[Value]*[Allocation]/100,0)).

I realize this last formula is messy - all the fields in this last formula
are from the query or another form that is open.

Any help? Why am I getting #Name? for each of these formulas?

Thanks
Click to expand...
Click to expand...
 
FYI:

I fixed the problem by creating a new form that is exactly the same as the
original. I don't know why that worked though. I've encountered this
"solution" before - it's a little frustrating, but at least it's working.

kabaka said:
Thanks for the suggestion - no luck though.

In an attempt to simplify things on the form (hoping that might solve the
problem), I have changed the query so that I do not reference another
calculated control in any other control. In the detail section I now have
[Hedges] as the control formula - which works - and =sum([Hedges]) in the
footer - which does not work.


Lynn Trapp said:
Try putting Sum(=[PACE_SUMM_HEDGE]/1000000+[Hedge_adj]-[Hedge_val]) in the
control instead.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html



kabaka said:
Hi,

First my apologies - I posted a question similar to this a couple of weeks
back, subsequently got sidetracked with other tasks and couldn't get back
to
this problem until now. Hence the repost of my old question.

I have a form based on a query; on the form in the detail section is a
calculated control =[PACE_SUMM_HEDGE]/1000000+[Hedge_adj]-[Hedge_val].
Note:
the fields [PACE_SUMM_HEDGE] & [Hedge_adj] are from the query while
[Hedge_val] is the name of another calculated control (also in the detail
section). I have named this control "Hedges". This works fine.

I would like to sum this calculation in the footer section; my calculated
control has the formula =sum([Hedges]). This does NOT work - it returns
#Name?

As does the formula
=Sum([PACE_SUMM_HEDGE]/1000000+[Hedge_adj]-[Hedge_val]).

As does the formula
=Sum([PACE_SUMM_HEDGE]/1000000+[Hedge_adj]-IIf([Forms]![Adjustments
Page]![Type Combo].[Value]="Hedges",[Forms]![Adjustments
Page]![Amount].[Value]*[Allocation]/100,0)).

I realize this last formula is messy - all the fields in this last formula
are from the query or another form that is open.

Any help? Why am I getting #Name? for each of these formulas?

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