Form Detail Sum

[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]

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.

 

[sweet_dreams]

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.

Hi,

Check your spelling:

=Sum([lineCostCalc])

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

Hope this helps.
regards,
Sebastian

 

[tom]

It is right in the DB, wrong in the newsgroup.

I sent a correction.

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.

Hi,

Check your spelling:

=Sum([lineCostCalc])

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

Hope this helps.
regards,
Sebastian

 

[Roger Carlson]

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

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.

 

[tom]

This will not work either.

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

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.