Help Please.

[Guest]

Hi all:
I know this section of the discussion group is meant for Forms; but I have
posted this question on the reports section and have not recieved any
response. There always seems to be more intrest and traffic on the forms
section so I thought I would try my post here. I hope someone can help me.

What I am trying to do is calculate the sum of a control on a sub report that
refeers to some fields on the main report. In the detail section of the sub
report the control calculates the values correctly and it references some
fields on my main report. Yet when I try to calculate the total for the
control in the footer section it treats my reference to the fields on my main
report as paramater values. For the life of me I can not figure out what I
am doing wrong. Can anyone help please?

Main Report Name: rptDailyProductionApples

Sub report Name: rptDailyProductionApplestblWipDistLabsubreport

Control on sub report (in detail section) to be totaled: txtUnitCostProd

Contents of [txtUnitCostProd]:
=IIf([GlCode]="61269-02",+[Reports]![rptDailyProductionApples]![txtSetUpUnitCost]+[Reports]![rptDailyProductionApples]![txtProductionUnitCost]+[Reports]![rptDailyProductionApples]![txtCleanUpUnitCost],[txtOtherExpenseUnitCost])

I have tried entering the following with both resulting in the "paramater
value" issue.

=sum([txtUnitCostProd]) and

=sum(IIf([GlCode]="61269-02",+[Reports]![rptDailyProductionApples]![txtSetUpUnitCost]+[Reports]![rptDailyProductionApples]![txtProductionUnitCost]+[Reports]![rptDailyProductionApples]![txtCleanUpUnitCost],[txtOtherExpenseUnitCost]))

Can anyone help pelase?

Thanks,
FatMan

 

[Jeff Boyce]

Looking for my keys under the streetlight, because there's more light there
.... reminds me of a joke.

For the future, if the folks who are volunteering in the Reports group don't
get right back, or don't have an idea they think will help, or maybe are off
at their day job, you may have to wait longer. If you have an emergency and
need an immediate solution, you may have to hire someone to help.

If I had to take a wild stab (since you haven't posted the formulae you're
using), I'd guess that the way the expression refers to the controls may
need tweaking. Check Access HELP for "expressions" and see if the
expression you're using matches the example in HELP.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Guest]

Jeff:
Thank you for your reply. I totaly understand that this is not the
"reports" section of the discussion group and did explain that fact in my
post. I thought since there is such a close relation between forms/sub-froms
and reports/sub-reports that maybe...just maybe some access guru might offer
me some help. I see that I was wrong and apologize to everyone in this
discussion group for my error.

I sorry that you felt you needed to take a wild stab as to the formulae I
was trying to use as both of them were listed in my original post and were
prefaced by ...." have tried entering the following with both resulting in
the "paramater value" issue." Kind of reminds me of a joke.....can't see the
trees through the forest.

Once gain thank you for your help and my apologies for posting this in the
forms section of the discussion group. I simply thought that since there
appears to me a lot more of Access gurus in the forms discussion group that
maybe one would help me a lilttle. My bad!

Thanks,
FatMan

Looking for my keys under the streetlight, because there's more light there
.... reminds me of a joke.

For the future, if the folks who are volunteering in the Reports group don't
get right back, or don't have an idea they think will help, or maybe are off
at their day job, you may have to wait longer. If you have an emergency and
need an immediate solution, you may have to hire someone to help.

If I had to take a wild stab (since you haven't posted the formulae you're
using), I'd guess that the way the expression refers to the controls may
need tweaking. Check Access HELP for "expressions" and see if the
expression you're using matches the example in HELP.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Hi all:
I know this section of the discussion group is meant for Forms; but I have
posted this question on the reports section and have not recieved any
response. There always seems to be more intrest and traffic on the forms
section so I thought I would try my post here. I hope someone can help me.

What I am trying to do is calculate the sum of a control on a sub report that
refeers to some fields on the main report. In the detail section of the sub
report the control calculates the values correctly and it references some
fields on my main report. Yet when I try to calculate the total for the
control in the footer section it treats my reference to the fields on my main
report as paramater values. For the life of me I can not figure out what I
am doing wrong. Can anyone help please?

Main Report Name: rptDailyProductionApples

Sub report Name: rptDailyProductionApplestblWipDistLabsubreport

Control on sub report (in detail section) to be totaled: txtUnitCostProd

Contents of [txtUnitCostProd]:
=IIf([GlCode]="61269-02",+[Reports]![rptDailyProductionApples]![txtSetUpUnit
Cost]+[Reports]![rptDailyProductionApples]![txtProductionUnitCost]+[Reports]
![rptDailyProductionApples]![txtCleanUpUnitCost],[txtOtherExpenseUnitCost])

I have tried entering the following with both resulting in the "paramater
value" issue.

=sum([txtUnitCostProd]) and

=sum(IIf([GlCode]="61269-02",+[Reports]![rptDailyProductionApples]![txtSetUp
UnitCost]+[Reports]![rptDailyProductionApples]![txtProductionUnitCost]+[Repo
rts]![rptDailyProductionApples]![txtCleanUpUnitCost],[txtOtherExpenseUnitCos
t]))

Can anyone help pelase?

Thanks,
FatMan

 

[Jeff Boyce]

If my response offended you, I apologize. And my "wild stab" was that the
way that you referred to the control on the subreport may not be the way
Access needs to see the syntax. If you'll check Access HELP for
"expression" there should be examples of how to refer to controls on
subforms and subreports.

You're right, forms & reports both seem to have a lot in common.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Jeff:
Thank you for your reply. I totaly understand that this is not the
"reports" section of the discussion group and did explain that fact in my
post. I thought since there is such a close relation between forms/sub-froms
and reports/sub-reports that maybe...just maybe some access guru might offer
me some help. I see that I was wrong and apologize to everyone in this
discussion group for my error.

I sorry that you felt you needed to take a wild stab as to the formulae I
was trying to use as both of them were listed in my original post and were
prefaced by ...." have tried entering the following with both resulting in
the "paramater value" issue." Kind of reminds me of a joke.....can't see the
trees through the forest.

Once gain thank you for your help and my apologies for posting this in the
forms section of the discussion group. I simply thought that since there
appears to me a lot more of Access gurus in the forms discussion group that
maybe one would help me a lilttle. My bad!

Thanks,
FatMan

Looking for my keys under the streetlight, because there's more light there
.... reminds me of a joke.

For the future, if the folks who are volunteering in the Reports group don't
get right back, or don't have an idea they think will help, or maybe are off
at their day job, you may have to wait longer. If you have an emergency and
need an immediate solution, you may have to hire someone to help.

If I had to take a wild stab (since you haven't posted the formulae you're
using), I'd guess that the way the expression refers to the controls may
need tweaking. Check Access HELP for "expressions" and see if the
expression you're using matches the example in HELP.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Hi all:
I know this section of the discussion group is meant for Forms; but I have
posted this question on the reports section and have not recieved any
response. There always seems to be more intrest and traffic on the forms
section so I thought I would try my post here. I hope someone can

help
me.

What I am trying to do is calculate the sum of a control on a sub

report
that

refeers to some fields on the main report. In the detail section of

the
sub

report the control calculates the values correctly and it references some
fields on my main report. Yet when I try to calculate the total for the
control in the footer section it treats my reference to the fields on

my
main

report as paramater values. For the life of me I can not figure out

what
I

am doing wrong. Can anyone help please?

Main Report Name: rptDailyProductionApples

Sub report Name: rptDailyProductionApplestblWipDistLabsubreport

Control on sub report (in detail section) to be totaled: txtUnitCostProd

Contents of [txtUnitCostProd]:

=IIf([GlCode]="61269-02",+[Reports]![rptDailyProductionApples]![txtSetUpUnit
Cost]+[Reports]![rptDailyProductionApples]![txtProductionUnitCost]+[Reports]
![rptDailyProductionApples]![txtCleanUpUnitCost],[txtOtherExpenseUnitCost])

I have tried entering the following with both resulting in the "paramater
value" issue.

=sum([txtUnitCostProd]) and

=sum(IIf([GlCode]="61269-02",+[Reports]![rptDailyProductionApples]![txtSetUp
UnitCost]+[Reports]![rptDailyProductionApples]![txtProductionUnitCost]+[Repo
rts]![rptDailyProductionApples]![txtCleanUpUnitCost],[txtOtherExpenseUnitCos
t]))

Can anyone help pelase?

Thanks,
FatMan