Form Detail Sum

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

I wanted to make more clear my problem in an earlier post.

In the detail section of the form I have a text box named
LineCalcCost, in this text box there is control source,

=CalcCost(w,x,y,z)

This part is working.

I then have a text box in the footer with the control source

=Sum([lineCostCalc])

I am getting a name error on this. I am using here the actual names in the
DB.
 
tom said:
I wanted to make more clear my problem in an earlier post.

In the detail section of the form I have a text box named
LineCostCalc, in this text box there is control source,

=CalcCost(w,x,y,z)

This part is working.

I then have a text box in the footer with the control source

=Sum([lineCostCalc])

I am getting a name error on this. I am using here the actual names in
the DB.
Click to expand...
 
I wanted to make more clear my problem in an earlier post.

In the detail section of the form I have a text box named
LineCalcCost, in this text box there is control source,

=CalcCost(w,x,y,z)

This part is working.

I then have a text box in the footer with the control source

=Sum([lineCostCalc])

I am getting a name error on this. I am using here the actual names in the
DB.
Click to expand...

Hi,

Check your spelling:
you said:
=Sum([lineCostCalc])
Click to expand...

whereas it should be:
=Sum([LineCalcCost])

Hope this helps.
regards,
Sebastian
 
It is right in the DB, wrong in the newsgroup.

I sent a correction.


sweet_dreams said:
I wanted to make more clear my problem in an earlier post.

In the detail section of the form I have a text box named
LineCalcCost, in this text box there is control source,

=CalcCost(w,x,y,z)

This part is working.

I then have a text box in the footer with the control source

=Sum([lineCostCalc])

I am getting a name error on this. I am using here the actual names in
the
DB.
Click to expand...

Hi,

Check your spelling:
you said:
=Sum([lineCostCalc])
Click to expand...

whereas it should be:
=Sum([LineCalcCost])

Hope this helps.
regards,
Sebastian
Click to expand...
 
You can't use the name of the other control in your Sum function. You'll
have to use:

=Sum(CalcCost(w,x,y,z))


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

tom said:
tom said:
I wanted to make more clear my problem in an earlier post.

In the detail section of the form I have a text box named
LineCostCalc, in this text box there is control source,

=CalcCost(w,x,y,z)

This part is working.

I then have a text box in the footer with the control source

=Sum([lineCostCalc])

I am getting a name error on this. I am using here the actual names in
the DB.
Click to expand...
Click to expand...
 
This will not work either.


Roger Carlson said:
You can't use the name of the other control in your Sum function. You'll
have to use:

=Sum(CalcCost(w,x,y,z))


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

tom said:
tom said:
I wanted to make more clear my problem in an earlier post.

In the detail section of the form I have a text box named
LineCostCalc, in this text box there is control source,

=CalcCost(w,x,y,z)

This part is working.

I then have a text box in the footer with the control source

=Sum([lineCostCalc])

I am getting a name error on this. I am using here the actual names in
the DB.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top