Question about wording and position overall total not correct

[znibk]

Please forgive me if I am double posting, I do not mean to. I need help and
did not get a response to "Puzzling Problems" and it does not come up when I
check it, so I am not sure it posted.

I have tried over and over again, various combinations, names, and
placements within report and sub-report footers, etc. for these two problems,
but am unable to come up with the correct answer. I once again hope there is
someone out there who can help me.

I am trying to achieve the Yearly Bank Balance. I have, a report in which I
first have a Beginning Balance Bank Header, nothing is in it expcept the bank
name.

In the detail section, I have the beginning balance. [Abegbal] Added to that
detail section, I have sub_report_income_yearly in which I have a text box
with the name TxtTotalAssets and a Control Source of =[Abegbal]+[txtincsum].
I get the total I need when I run the report.

Also in the detail section, I have subrpt_expense_yearly. In this
sub-report, I have a total expense. Name [TxtExpenseSum] Control Source
=Sum([CkAmt]) Again, I get the total I need when I run the report.

When I first started a smaller version of this project, I was instructed to
put in the detail section: two text boxes, one containing
=iif([sub_report_expense_yearly].[report].[has
data].[sub_report_expense_yearly].[txtExpenseSum],0) and another with
=iif[sub_report_income_yearly].report.[has data].[txttotalassets],0])

To obtain the ending balance, I have placed the following in both the
bankfooter and in the report footer. In neither, do I get the result I
desire.

I seem to have two problems. The one stated aboveof not getting the desired
answer, but also the label to the txt box keeps yeilding the name
TxtExpenseSum rather than the name I gave to the result, TxtAEndBal.

In the Text Box, I have the Name TxtAEndBal and Control Source of
=([txttotalassets]-txtexpensesum.

I also know how to show a negative balance, in the event we ever have one.

I hope I have written my question so that you can understand it and I await
with a humble heart and mind, for help with this problem.

You all have been so great to help me out in the past, so I hope you can
help me with these problems.

Thank you and God Bless,

K

 

[Duane Hookom]

Your expressions have lots of errors. Did you copy and paste these in your
message?
Try:
Name:txtSumExpenses
Control Source:=IIf([sub_report_expense_yearly].[report].[hasdata],
[sub_report_expense_yearly].Report.[txtExpenseSum],0)

Name:txtSumAssets
Control Source:=IIf([sub_report_income_yearly].report.[has data],
[sub_report_income_yearly].report.[txttotalassets],0])

If you need these values to display in another section (group or report
footer) you must reference the control name from the detail section:
Control Source: =txtSumExpenses
Control Source: =txtSumAssets

--
Duane Hookom
Microsoft Access MVP

Please forgive me if I am double posting, I do not mean to. I need help and
did not get a response to "Puzzling Problems" and it does not come up when I
check it, so I am not sure it posted.

I have tried over and over again, various combinations, names, and
placements within report and sub-report footers, etc. for these two problems,
but am unable to come up with the correct answer. I once again hope there is
someone out there who can help me.

I am trying to achieve the Yearly Bank Balance. I have, a report in which I
first have a Beginning Balance Bank Header, nothing is in it expcept the bank
name.

In the detail section, I have the beginning balance. [Abegbal] Added to that
detail section, I have sub_report_income_yearly in which I have a text box
with the name TxtTotalAssets and a Control Source of =[Abegbal]+[txtincsum].
I get the total I need when I run the report.

Also in the detail section, I have subrpt_expense_yearly. In this
sub-report, I have a total expense. Name [TxtExpenseSum] Control Source
=Sum([CkAmt]) Again, I get the total I need when I run the report.

When I first started a smaller version of this project, I was instructed to
put in the detail section: two text boxes, one containing
=iif([sub_report_expense_yearly].[report].[has
data].[sub_report_expense_yearly].[txtExpenseSum],0) and another with
=iif[sub_report_income_yearly].report.[has data].[txttotalassets],0])

To obtain the ending balance, I have placed the following in both the
bankfooter and in the report footer. In neither, do I get the result I
desire.

I seem to have two problems. The one stated aboveof not getting the desired
answer, but also the label to the txt box keeps yeilding the name
TxtExpenseSum rather than the name I gave to the result, TxtAEndBal.

In the Text Box, I have the Name TxtAEndBal and Control Source of
=([txttotalassets]-txtexpensesum.

I also know how to show a negative balance, in the event we ever have one.

I hope I have written my question so that you can understand it and I await
with a humble heart and mind, for help with this problem.

You all have been so great to help me out in the past, so I hope you can
help me with these problems.

Thank you and God Bless,

K

 

[znibk]

Duane,

God bless you for helping, and you did help, we just aren't there yet. When
we get the two errors below corrected, I have another one I would like help
with, then again, who knows, I may have it correct, Miracles Happen ALL the
time.

To answer your question about the copy and paste, actually, I typed
everything and in my attempt to be careful, and the fact that I was
completely exhausted when I finally gave up all attempts and said “Karen, ask
for help.†Anyway, I succeeded in interchanging some of the names in the
several sub-reports, I am working on trying to get one report which covers
two different banks.

I still am unable to gain an ending balance.


However, I have gone back and corrected the errors in the sub-reports, I
think.

In the detail section, I have

Name: txtSumExpenses
Control Source: =IIf([SubRpt_Expenses_Yearly].[Report].[has
data],[SubRpt_Expenses_Yearly].[Report].[txtSumExpenses],0)


Name: txtSumIncome
Control Source: =IIf([SubRpt_Income_Yearly].[Report].[has
data],[SubRpt_Income_Yearly].[Report].[txtSumIncome],0)

No matter if I put the following in the Beginning Footer OR in the Report
Footer, I still do not, as stated above, get a Year End Sum.

Name: txtYrEndSum
Control Source: = Sum [TxtSumIncome]-[TxtSumExpense]

Also, I get #Name? error under each of the txtSumExpenses and txtSumIncome
Name and Control Source.

Duane, what oh what, am I NOT DOING correctly?

Christ's blessings,

Karen

Your expressions have lots of errors. Did you copy and paste these in your
message?
Try:
Name:txtSumExpenses
Control Source:=IIf([sub_report_expense_yearly].[report].[hasdata],
[sub_report_expense_yearly].Report.[txtExpenseSum],0)

Name:txtSumAssets
Control Source:=IIf([sub_report_income_yearly].report.[has data],
[sub_report_income_yearly].report.[txttotalassets],0])

If you need these values to display in another section (group or report
footer) you must reference the control name from the detail section:
Control Source: =txtSumExpenses
Control Source: =txtSumAssets

--
Duane Hookom
Microsoft Access MVP

Please forgive me if I am double posting, I do not mean to. I need help and
did not get a response to "Puzzling Problems" and it does not come up when I
check it, so I am not sure it posted.

I have tried over and over again, various combinations, names, and
placements within report and sub-report footers, etc. for these two problems,
but am unable to come up with the correct answer. I once again hope there is
someone out there who can help me.

I am trying to achieve the Yearly Bank Balance. I have, a report in which I
first have a Beginning Balance Bank Header, nothing is in it expcept the bank
name.

In the detail section, I have the beginning balance. [Abegbal] Added to that
detail section, I have sub_report_income_yearly in which I have a text box
with the name TxtTotalAssets and a Control Source of =[Abegbal]+[txtincsum].
I get the total I need when I run the report.

Also in the detail section, I have subrpt_expense_yearly. In this
sub-report, I have a total expense. Name [TxtExpenseSum] Control Source
=Sum([CkAmt]) Again, I get the total I need when I run the report.

When I first started a smaller version of this project, I was instructed to
put in the detail section: two text boxes, one containing
=iif([sub_report_expense_yearly].[report].[has
data].[sub_report_expense_yearly].[txtExpenseSum],0) and another with
=iif[sub_report_income_yearly].report.[has data].[txttotalassets],0])

To obtain the ending balance, I have placed the following in both the
bankfooter and in the report footer. In neither, do I get the result I
desire.

I seem to have two problems. The one stated aboveof not getting the desired
answer, but also the label to the txt box keeps yeilding the name
TxtExpenseSum rather than the name I gave to the result, TxtAEndBal.

In the Text Box, I have the Name TxtAEndBal and Control Source of
=([txttotalassets]-txtexpensesum.

I also know how to show a negative balance, in the event we ever have one.

I hope I have written my question so that you can understand it and I await
with a humble heart and mind, for help with this problem.

You all have been so great to help me out in the past, so I hope you can
help me with these problems.

Thank you and God Bless,

K

 

[Duane Hookom]

If the two text boxes don't work, then attempting to subtract one from the
other won't work.
Are you using the name of the subreport controls or the name of the Source
Object? Do you know the difference?

I don't know why you would use Sum and then not have any ()s. If the text
boxes worked you would just use:

Control Source: =[TxtSumIncome]-[TxtSumExpense]
--
Duane Hookom
Microsoft Access MVP

Duane,

God bless you for helping, and you did help, we just aren't there yet. When
we get the two errors below corrected, I have another one I would like help
with, then again, who knows, I may have it correct, Miracles Happen ALL the
time.

To answer your question about the copy and paste, actually, I typed
everything and in my attempt to be careful, and the fact that I was
completely exhausted when I finally gave up all attempts and said “Karen, ask
for help.†Anyway, I succeeded in interchanging some of the names in the
several sub-reports, I am working on trying to get one report which covers
two different banks.

I still am unable to gain an ending balance.


However, I have gone back and corrected the errors in the sub-reports, I
think.

In the detail section, I have

Name: txtSumExpenses
Control Source: =IIf([SubRpt_Expenses_Yearly].[Report].[has
data],[SubRpt_Expenses_Yearly].[Report].[txtSumExpenses],0)


Name: txtSumIncome
Control Source: =IIf([SubRpt_Income_Yearly].[Report].[has
data],[SubRpt_Income_Yearly].[Report].[txtSumIncome],0)

No matter if I put the following in the Beginning Footer OR in the Report
Footer, I still do not, as stated above, get a Year End Sum.

Name: txtYrEndSum
Control Source: = Sum [TxtSumIncome]-[TxtSumExpense]

Also, I get #Name? error under each of the txtSumExpenses and txtSumIncome
Name and Control Source.

Duane, what oh what, am I NOT DOING correctly?

Christ's blessings,

Karen

Your expressions have lots of errors. Did you copy and paste these in your
message?
Try:
Name:txtSumExpenses
Control Source:=IIf([sub_report_expense_yearly].[report].[hasdata],
[sub_report_expense_yearly].Report.[txtExpenseSum],0)

Name:txtSumAssets
Control Source:=IIf([sub_report_income_yearly].report.[has data],
[sub_report_income_yearly].report.[txttotalassets],0])

If you need these values to display in another section (group or report
footer) you must reference the control name from the detail section:
Control Source: =txtSumExpenses
Control Source: =txtSumAssets

--
Duane Hookom
Microsoft Access MVP

Please forgive me if I am double posting, I do not mean to. I need help and
did not get a response to "Puzzling Problems" and it does not come up when I
check it, so I am not sure it posted.

I have tried over and over again, various combinations, names, and
placements within report and sub-report footers, etc. for these two problems,
but am unable to come up with the correct answer. I once again hope there is
someone out there who can help me.

I am trying to achieve the Yearly Bank Balance. I have, a report in which I
first have a Beginning Balance Bank Header, nothing is in it expcept the bank
name.

In the detail section, I have the beginning balance. [Abegbal] Added to that
detail section, I have sub_report_income_yearly in which I have a text box
with the name TxtTotalAssets and a Control Source of =[Abegbal]+[txtincsum].
I get the total I need when I run the report.

Also in the detail section, I have subrpt_expense_yearly. In this
sub-report, I have a total expense. Name [TxtExpenseSum] Control Source
=Sum([CkAmt]) Again, I get the total I need when I run the report.

When I first started a smaller version of this project, I was instructed to
put in the detail section: two text boxes, one containing
=iif([sub_report_expense_yearly].[report].[has
data].[sub_report_expense_yearly].[txtExpenseSum],0) and another with
=iif[sub_report_income_yearly].report.[has data].[txttotalassets],0])

To obtain the ending balance, I have placed the following in both the
bankfooter and in the report footer. In neither, do I get the result I
desire.

I seem to have two problems. The one stated aboveof not getting the desired
answer, but also the label to the txt box keeps yeilding the name
TxtExpenseSum rather than the name I gave to the result, TxtAEndBal.

In the Text Box, I have the Name TxtAEndBal and Control Source of
=([txttotalassets]-txtexpensesum.

I also know how to show a negative balance, in the event we ever have one.

I hope I have written my question so that you can understand it and I await
with a humble heart and mind, for help with this problem.

You all have been so great to help me out in the past, so I hope you can
help me with these problems.

Thank you and God Bless,

K

 

[znibk]

Duane,

Duane,

Do I feel like a GIANT DOOP, I fixed all the accidental errors in the
SubRpt_Expenses_Yearly but have not fixed them in the SubRpt_Income_Yearly.

I do have a question, I have called the total of all of my income,
txtincsum. I had planned to have:

Name: TxtTotalAssets
Control Source: [begbal]+[txtincsum]

is that okay or do I have to rename?

Also, I have several beginning balances in one query, so that I get the
correct beginning balance, I have under the date field,
[form]![BBDate]![txtStat] In the event that I do not ask for only one
beginning balance, I am concerned that the beginning balance from the query
at the first of each month will automatically figure into the total assets,
is that an uncessary concern?

then when I enter the rest of the information, for the income and for the
expenses, I have in the date field in the query Between
[form]![frmDATES]![txtstart] And [form]![frmDATES]![txtend], are those
parameters acceptable or do I need to do something else?

Please check my thread as it is midnight here and I do need to get some
sleep. I have an extremely long day tomorrow and will have to work this in
once I make my corrections in the SubRpt_Income_Yearly after checking your
response to these questions later this morning.

One other quick question--does it make any difference in what section of a
subreport or report that I put

Name: txtSumExpenses
Control Source: =IIf([SubRpt_Expenses_Yearly].[Report].[has
data],[SubRpt_Expenses_Yearly].[Report].[txtSumExpenses],0)

or the Name:txtSumIncome etc. and does the expense information need to be in
the SubReport or does the final Report just need to contain both sets of
information?

Thank you, Good night, and God bless,

Karen

If the two text boxes don't work, then attempting to subtract one from the
other won't work.
Are you using the name of the subreport controls or the name of the Source
Object? Do you know the difference?

I don't know why you would use Sum and then not have any ()s. If the text
boxes worked you would just use:

Control Source: =[TxtSumIncome]-[TxtSumExpense]
--
Duane Hookom
Microsoft Access MVP

Duane,

God bless you for helping, and you did help, we just aren't there yet. When
we get the two errors below corrected, I have another one I would like help
with, then again, who knows, I may have it correct, Miracles Happen ALL the
time.

To answer your question about the copy and paste, actually, I typed
everything and in my attempt to be careful, and the fact that I was
completely exhausted when I finally gave up all attempts and said “Karen, ask
for help.†Anyway, I succeeded in interchanging some of the names in the
several sub-reports, I am working on trying to get one report which covers
two different banks.

I still am unable to gain an ending balance.


However, I have gone back and corrected the errors in the sub-reports, I
think.

In the detail section, I have

Name: txtSumExpenses
Control Source: =IIf([SubRpt_Expenses_Yearly].[Report].[has
data],[SubRpt_Expenses_Yearly].[Report].[txtSumExpenses],0)


Name: txtSumIncome
Control Source: =IIf([SubRpt_Income_Yearly].[Report].[has
data],[SubRpt_Income_Yearly].[Report].[txtSumIncome],0)

No matter if I put the following in the Beginning Footer OR in the Report
Footer, I still do not, as stated above, get a Year End Sum.

Name: txtYrEndSum
Control Source: = Sum [TxtSumIncome]-[TxtSumExpense]

Also, I get #Name? error under each of the txtSumExpenses and txtSumIncome
Name and Control Source.

Duane, what oh what, am I NOT DOING correctly?

Christ's blessings,

Karen

Your expressions have lots of errors. Did you copy and paste these in your
message?
Try:
Name:txtSumExpenses
Control Source:=IIf([sub_report_expense_yearly].[report].[hasdata],
[sub_report_expense_yearly].Report.[txtExpenseSum],0)

Name:txtSumAssets
Control Source:=IIf([sub_report_income_yearly].report.[has data],
[sub_report_income_yearly].report.[txttotalassets],0])

If you need these values to display in another section (group or report
footer) you must reference the control name from the detail section:
Control Source: =txtSumExpenses
Control Source: =txtSumAssets

--
Duane Hookom
Microsoft Access MVP


:

Please forgive me if I am double posting, I do not mean to. I need help and
did not get a response to "Puzzling Problems" and it does not come up when I
check it, so I am not sure it posted.

I have tried over and over again, various combinations, names, and
placements within report and sub-report footers, etc. for these two problems,
but am unable to come up with the correct answer. I once again hope there is
someone out there who can help me.

I am trying to achieve the Yearly Bank Balance. I have, a report in which I
first have a Beginning Balance Bank Header, nothing is in it expcept the bank
name.

In the detail section, I have the beginning balance. [Abegbal] Added to that
detail section, I have sub_report_income_yearly in which I have a text box
with the name TxtTotalAssets and a Control Source of =[Abegbal]+[txtincsum].
I get the total I need when I run the report.

Also in the detail section, I have subrpt_expense_yearly. In this
sub-report, I have a total expense. Name [TxtExpenseSum] Control Source
=Sum([CkAmt]) Again, I get the total I need when I run the report.

When I first started a smaller version of this project, I was instructed to
put in the detail section: two text boxes, one containing
=iif([sub_report_expense_yearly].[report].[has
data].[sub_report_expense_yearly].[txtExpenseSum],0) and another with
=iif[sub_report_income_yearly].report.[has data].[txttotalassets],0])

To obtain the ending balance, I have placed the following in both the
bankfooter and in the report footer. In neither, do I get the result I
desire.

I seem to have two problems. The one stated aboveof not getting the desired
answer, but also the label to the txt box keeps yeilding the name
TxtExpenseSum rather than the name I gave to the result, TxtAEndBal.

In the Text Box, I have the Name TxtAEndBal and Control Source of
=([txttotalassets]-txtexpensesum.

I also know how to show a negative balance, in the event we ever have one.

I hope I have written my question so that you can understand it and I await
with a humble heart and mind, for help with this problem.

You all have been so great to help me out in the past, so I hope you can
help me with these problems.

Thank you and God Bless,

K

 

[Duane Hookom]

I doubt "[form]![BBDate]![txtStat]" will work since it should probably by
"[form]![BBDate]![txtStart]". Also in all cases, you should be using [Forms]
not [form]. Please copy and paste your expressions so the syntax matches your
actual and I can see the upper and lower case letters.

Here's what I know about retrieving values from a subreport into a main
report:

- A subreport is a control on your main report
- The subreport control has "Name" and "Source Object" properties
These are often the same value but might be different. When
they are different, you need to use the "Name" property, not the
"Source Object".
* assume the subreport control name is "srptOne"
- The typical setup has a text box in the report footer of the subreport
containing an aggregated value.
* assume this text box is "txtSumQty"
- You can add a text box on the main report in the same section as the
subreport with an expression like:
* assume this text box is "txtSumFromsrptOne"
=srptOne.Report.txtSumQty
- If your subreport might not return any records, you need to use
=IIf(srptOne.Report.HasData, srptOne.Report.txtSumQt, 0)
- If you want the value from the subreport to be displayed in a section
of the main report other than section containing the subreport:
- create txtSumFromsrptOne as above and
- add a text box in the other section with a control source of:
=txtSumFromsrptOne
--
Duane Hookom
Microsoft Access MVP

Duane,

Duane,

Do I feel like a GIANT DOOP, I fixed all the accidental errors in the
SubRpt_Expenses_Yearly but have not fixed them in the SubRpt_Income_Yearly.

I do have a question, I have called the total of all of my income,
txtincsum. I had planned to have:

Name: TxtTotalAssets
Control Source: [begbal]+[txtincsum]

is that okay or do I have to rename?

Also, I have several beginning balances in one query, so that I get the
correct beginning balance, I have under the date field,
[form]![BBDate]![txtStat] In the event that I do not ask for only one
beginning balance, I am concerned that the beginning balance from the query
at the first of each month will automatically figure into the total assets,
is that an uncessary concern?

then when I enter the rest of the information, for the income and for the
expenses, I have in the date field in the query Between
[form]![frmDATES]![txtstart] And [form]![frmDATES]![txtend], are those
parameters acceptable or do I need to do something else?

Please check my thread as it is midnight here and I do need to get some
sleep. I have an extremely long day tomorrow and will have to work this in
once I make my corrections in the SubRpt_Income_Yearly after checking your
response to these questions later this morning.

One other quick question--does it make any difference in what section of a
subreport or report that I put

Name: txtSumExpenses
Control Source: =IIf([SubRpt_Expenses_Yearly].[Report].[has
data],[SubRpt_Expenses_Yearly].[Report].[txtSumExpenses],0)

or the Name:txtSumIncome etc. and does the expense information need to be in
the SubReport or does the final Report just need to contain both sets of
information?

Thank you, Good night, and God bless,

Karen

If the two text boxes don't work, then attempting to subtract one from the
other won't work.
Are you using the name of the subreport controls or the name of the Source
Object? Do you know the difference?

I don't know why you would use Sum and then not have any ()s. If the text
boxes worked you would just use:

Control Source: =[TxtSumIncome]-[TxtSumExpense]
--
Duane Hookom
Microsoft Access MVP

Duane,

God bless you for helping, and you did help, we just aren't there yet. When
we get the two errors below corrected, I have another one I would like help
with, then again, who knows, I may have it correct, Miracles Happen ALL the
time.

To answer your question about the copy and paste, actually, I typed
everything and in my attempt to be careful, and the fact that I was
completely exhausted when I finally gave up all attempts and said “Karen, ask
for help.†Anyway, I succeeded in interchanging some of the names in the
several sub-reports, I am working on trying to get one report which covers
two different banks.

I still am unable to gain an ending balance.


However, I have gone back and corrected the errors in the sub-reports, I
think.

In the detail section, I have

Name: txtSumExpenses
Control Source: =IIf([SubRpt_Expenses_Yearly].[Report].[has
data],[SubRpt_Expenses_Yearly].[Report].[txtSumExpenses],0)


Name: txtSumIncome
Control Source: =IIf([SubRpt_Income_Yearly].[Report].[has
data],[SubRpt_Income_Yearly].[Report].[txtSumIncome],0)

No matter if I put the following in the Beginning Footer OR in the Report
Footer, I still do not, as stated above, get a Year End Sum.

Name: txtYrEndSum
Control Source: = Sum [TxtSumIncome]-[TxtSumExpense]

Also, I get #Name? error under each of the txtSumExpenses and txtSumIncome
Name and Control Source.

Duane, what oh what, am I NOT DOING correctly?

Christ's blessings,

Karen


:

Your expressions have lots of errors. Did you copy and paste these in your
message?
Try:
Name:txtSumExpenses
Control Source:=IIf([sub_report_expense_yearly].[report].[hasdata],
[sub_report_expense_yearly].Report.[txtExpenseSum],0)

Name:txtSumAssets
Control Source:=IIf([sub_report_income_yearly].report.[has data],
[sub_report_income_yearly].report.[txttotalassets],0])

If you need these values to display in another section (group or report
footer) you must reference the control name from the detail section:
Control Source: =txtSumExpenses
Control Source: =txtSumAssets

--
Duane Hookom
Microsoft Access MVP


:

Please forgive me if I am double posting, I do not mean to. I need help and
did not get a response to "Puzzling Problems" and it does not come up when I
check it, so I am not sure it posted.

I have tried over and over again, various combinations, names, and
placements within report and sub-report footers, etc. for these two problems,
but am unable to come up with the correct answer. I once again hope there is
someone out there who can help me.

I am trying to achieve the Yearly Bank Balance. I have, a report in which I
first have a Beginning Balance Bank Header, nothing is in it expcept the bank
name.

In the detail section, I have the beginning balance. [Abegbal] Added to that
detail section, I have sub_report_income_yearly in which I have a text box
with the name TxtTotalAssets and a Control Source of =[Abegbal]+[txtincsum].
I get the total I need when I run the report.

Also in the detail section, I have subrpt_expense_yearly. In this
sub-report, I have a total expense. Name [TxtExpenseSum] Control Source
=Sum([CkAmt]) Again, I get the total I need when I run the report.

When I first started a smaller version of this project, I was instructed to
put in the detail section: two text boxes, one containing
=iif([sub_report_expense_yearly].[report].[has
data].[sub_report_expense_yearly].[txtExpenseSum],0) and another with
=iif[sub_report_income_yearly].report.[has data].[txttotalassets],0])

To obtain the ending balance, I have placed the following in both the
bankfooter and in the report footer. In neither, do I get the result I
desire.

I seem to have two problems. The one stated aboveof not getting the desired
answer, but also the label to the txt box keeps yeilding the name
TxtExpenseSum rather than the name I gave to the result, TxtAEndBal.

In the Text Box, I have the Name TxtAEndBal and Control Source of
=([txttotalassets]-txtexpensesum.

I also know how to show a negative balance, in the event we ever have one.

I hope I have written my question so that you can understand it and I await
with a humble heart and mind, for help with this problem.

You all have been so great to help me out in the past, so I hope you can
help me with these problems.

Thank you and God Bless,

K

 

[znibk]

Duane,

Finally getting back. I think I have that. However, when I use the "Between
[Forms]![FrmDATES]![TxtStart] And [Forms]![FrmDATES]![TxtEnd] I get about 27
pages of a report and the beginning balance, income, and expenses of each
month are included.

How can I just get the report to pull the beginning balance of the date I
give it, for example, 9/1/07.

FYI I have started writing the information of each subreport--the query,
text boxes, etc. but that is a lot of information and do not want to post it
unless absolutely necessary.

Thank you so much for you patience and help.

Karen

I doubt "[form]![BBDate]![txtStat]" will work since it should probably by
"[form]![BBDate]![txtStart]". Also in all cases, you should be using [Forms]
not [form]. Please copy and paste your expressions so the syntax matches your
actual and I can see the upper and lower case letters.

Here's what I know about retrieving values from a subreport into a main
report:

- A subreport is a control on your main report
- The subreport control has "Name" and "Source Object" properties
These are often the same value but might be different. When
they are different, you need to use the "Name" property, not the
"Source Object".
* assume the subreport control name is "srptOne"
- The typical setup has a text box in the report footer of the subreport
containing an aggregated value.
* assume this text box is "txtSumQty"
- You can add a text box on the main report in the same section as the
subreport with an expression like:
* assume this text box is "txtSumFromsrptOne"
=srptOne.Report.txtSumQty
- If your subreport might not return any records, you need to use
=IIf(srptOne.Report.HasData, srptOne.Report.txtSumQt, 0)
- If you want the value from the subreport to be displayed in a section
of the main report other than section containing the subreport:
- create txtSumFromsrptOne as above and
- add a text box in the other section with a control source of:
=txtSumFromsrptOne
--
Duane Hookom
Microsoft Access MVP

Duane,

Duane,

Do I feel like a GIANT DOOP, I fixed all the accidental errors in the
SubRpt_Expenses_Yearly but have not fixed them in the SubRpt_Income_Yearly.

I do have a question, I have called the total of all of my income,
txtincsum. I had planned to have:

Name: TxtTotalAssets
Control Source: [begbal]+[txtincsum]

is that okay or do I have to rename?

Also, I have several beginning balances in one query, so that I get the
correct beginning balance, I have under the date field,
[form]![BBDate]![txtStat] In the event that I do not ask for only one
beginning balance, I am concerned that the beginning balance from the query
at the first of each month will automatically figure into the total assets,
is that an uncessary concern?

then when I enter the rest of the information, for the income and for the
expenses, I have in the date field in the query Between
[form]![frmDATES]![txtstart] And [form]![frmDATES]![txtend], are those
parameters acceptable or do I need to do something else?

Please check my thread as it is midnight here and I do need to get some
sleep. I have an extremely long day tomorrow and will have to work this in
once I make my corrections in the SubRpt_Income_Yearly after checking your
response to these questions later this morning.

One other quick question--does it make any difference in what section of a
subreport or report that I put

Name: txtSumExpenses
Control Source: =IIf([SubRpt_Expenses_Yearly].[Report].[has
data],[SubRpt_Expenses_Yearly].[Report].[txtSumExpenses],0)

or the Name:txtSumIncome etc. and does the expense information need to be in
the SubReport or does the final Report just need to contain both sets of
information?

Thank you, Good night, and God bless,

Karen

If the two text boxes don't work, then attempting to subtract one from the
other won't work.
Are you using the name of the subreport controls or the name of the Source
Object? Do you know the difference?

I don't know why you would use Sum and then not have any ()s. If the text
boxes worked you would just use:

Control Source: =[TxtSumIncome]-[TxtSumExpense]
--
Duane Hookom
Microsoft Access MVP


:

Duane,

God bless you for helping, and you did help, we just aren't there yet. When
we get the two errors below corrected, I have another one I would like help
with, then again, who knows, I may have it correct, Miracles Happen ALL the
time.

To answer your question about the copy and paste, actually, I typed
everything and in my attempt to be careful, and the fact that I was
completely exhausted when I finally gave up all attempts and said “Karen, ask
for help.†Anyway, I succeeded in interchanging some of the names in the
several sub-reports, I am working on trying to get one report which covers
two different banks.

I still am unable to gain an ending balance.


However, I have gone back and corrected the errors in the sub-reports, I
think.

In the detail section, I have

Name: txtSumExpenses
Control Source: =IIf([SubRpt_Expenses_Yearly].[Report].[has
data],[SubRpt_Expenses_Yearly].[Report].[txtSumExpenses],0)


Name: txtSumIncome
Control Source: =IIf([SubRpt_Income_Yearly].[Report].[has
data],[SubRpt_Income_Yearly].[Report].[txtSumIncome],0)

No matter if I put the following in the Beginning Footer OR in the Report
Footer, I still do not, as stated above, get a Year End Sum.

Name: txtYrEndSum
Control Source: = Sum [TxtSumIncome]-[TxtSumExpense]

Also, I get #Name? error under each of the txtSumExpenses and txtSumIncome
Name and Control Source.

Duane, what oh what, am I NOT DOING correctly?

Christ's blessings,

Karen


:

Your expressions have lots of errors. Did you copy and paste these in your
message?
Try:
Name:txtSumExpenses
Control Source:=IIf([sub_report_expense_yearly].[report].[hasdata],
[sub_report_expense_yearly].Report.[txtExpenseSum],0)

Name:txtSumAssets
Control Source:=IIf([sub_report_income_yearly].report.[has data],
[sub_report_income_yearly].report.[txttotalassets],0])

If you need these values to display in another section (group or report
footer) you must reference the control name from the detail section:
Control Source: =txtSumExpenses
Control Source: =txtSumAssets

--
Duane Hookom
Microsoft Access MVP


:

Please forgive me if I am double posting, I do not mean to. I need help and
did not get a response to "Puzzling Problems" and it does not come up when I
check it, so I am not sure it posted.

I have tried over and over again, various combinations, names, and
placements within report and sub-report footers, etc. for these two problems,
but am unable to come up with the correct answer. I once again hope there is
someone out there who can help me.

I am trying to achieve the Yearly Bank Balance. I have, a report in which I
first have a Beginning Balance Bank Header, nothing is in it expcept the bank
name.

In the detail section, I have the beginning balance. [Abegbal] Added to that
detail section, I have sub_report_income_yearly in which I have a text box
with the name TxtTotalAssets and a Control Source of =[Abegbal]+[txtincsum].
I get the total I need when I run the report.

Also in the detail section, I have subrpt_expense_yearly. In this
sub-report, I have a total expense. Name [TxtExpenseSum] Control Source
=Sum([CkAmt]) Again, I get the total I need when I run the report.

When I first started a smaller version of this project, I was instructed to
put in the detail section: two text boxes, one containing
=iif([sub_report_expense_yearly].[report].[has
data].[sub_report_expense_yearly].[txtExpenseSum],0) and another with
=iif[sub_report_income_yearly].report.[has data].[txttotalassets],0])

To obtain the ending balance, I have placed the following in both the
bankfooter and in the report footer. In neither, do I get the result I
desire.

I seem to have two problems. The one stated aboveof not getting the desired
answer, but also the label to the txt box keeps yeilding the name
TxtExpenseSum rather than the name I gave to the result, TxtAEndBal.

In the Text Box, I have the Name TxtAEndBal and Control Source of
=([txttotalassets]-txtexpensesum.

I also know how to show a negative balance, in the event we ever have one.

I hope I have written my question so that you can understand it and I await
with a humble heart and mind, for help with this problem.

You all have been so great to help me out in the past, so I hope you can
help me with these problems.

Thank you and God Bless,

K

 

[Duane Hookom]

Please provide your background information in a reply. I don't recall your
report setup and what "wording and position" have to do with anything.

--
Duane Hookom
Microsoft Access MVP

Duane,

Finally getting back. I think I have that. However, when I use the "Between
[Forms]![FrmDATES]![TxtStart] And [Forms]![FrmDATES]![TxtEnd] I get about 27
pages of a report and the beginning balance, income, and expenses of each
month are included.

How can I just get the report to pull the beginning balance of the date I
give it, for example, 9/1/07.

FYI I have started writing the information of each subreport--the query,
text boxes, etc. but that is a lot of information and do not want to post it
unless absolutely necessary.

Thank you so much for you patience and help.

Karen

I doubt "[form]![BBDate]![txtStat]" will work since it should probably by
"[form]![BBDate]![txtStart]". Also in all cases, you should be using [Forms]
not [form]. Please copy and paste your expressions so the syntax matches your
actual and I can see the upper and lower case letters.

Here's what I know about retrieving values from a subreport into a main
report:

- A subreport is a control on your main report
- The subreport control has "Name" and "Source Object" properties
These are often the same value but might be different. When
they are different, you need to use the "Name" property, not the
"Source Object".
* assume the subreport control name is "srptOne"
- The typical setup has a text box in the report footer of the subreport
containing an aggregated value.
* assume this text box is "txtSumQty"
- You can add a text box on the main report in the same section as the
subreport with an expression like:
* assume this text box is "txtSumFromsrptOne"
=srptOne.Report.txtSumQty
- If your subreport might not return any records, you need to use
=IIf(srptOne.Report.HasData, srptOne.Report.txtSumQt, 0)
- If you want the value from the subreport to be displayed in a section
of the main report other than section containing the subreport:
- create txtSumFromsrptOne as above and
- add a text box in the other section with a control source of:
=txtSumFromsrptOne
--
Duane Hookom
Microsoft Access MVP

Duane,

Duane,

Do I feel like a GIANT DOOP, I fixed all the accidental errors in the
SubRpt_Expenses_Yearly but have not fixed them in the SubRpt_Income_Yearly.

I do have a question, I have called the total of all of my income,
txtincsum. I had planned to have:

Name: TxtTotalAssets
Control Source: [begbal]+[txtincsum]

is that okay or do I have to rename?

Also, I have several beginning balances in one query, so that I get the
correct beginning balance, I have under the date field,
[form]![BBDate]![txtStat] In the event that I do not ask for only one
beginning balance, I am concerned that the beginning balance from the query
at the first of each month will automatically figure into the total assets,
is that an uncessary concern?

then when I enter the rest of the information, for the income and for the
expenses, I have in the date field in the query Between
[form]![frmDATES]![txtstart] And [form]![frmDATES]![txtend], are those
parameters acceptable or do I need to do something else?

Please check my thread as it is midnight here and I do need to get some
sleep. I have an extremely long day tomorrow and will have to work this in
once I make my corrections in the SubRpt_Income_Yearly after checking your
response to these questions later this morning.

One other quick question--does it make any difference in what section of a
subreport or report that I put
Name: txtSumExpenses
Control Source: =IIf([SubRpt_Expenses_Yearly].[Report].[has
data],[SubRpt_Expenses_Yearly].[Report].[txtSumExpenses],0)

or the Name:txtSumIncome etc. and does the expense information need to be in
the SubReport or does the final Report just need to contain both sets of
information?

Thank you, Good night, and God bless,

Karen


:

If the two text boxes don't work, then attempting to subtract one from the
other won't work.
Are you using the name of the subreport controls or the name of the Source
Object? Do you know the difference?

I don't know why you would use Sum and then not have any ()s. If the text
boxes worked you would just use:

Control Source: =[TxtSumIncome]-[TxtSumExpense]
--
Duane Hookom
Microsoft Access MVP


:

Duane,

God bless you for helping, and you did help, we just aren't there yet. When
we get the two errors below corrected, I have another one I would like help
with, then again, who knows, I may have it correct, Miracles Happen ALL the
time.

To answer your question about the copy and paste, actually, I typed
everything and in my attempt to be careful, and the fact that I was
completely exhausted when I finally gave up all attempts and said “Karen, ask
for help.†Anyway, I succeeded in interchanging some of the names in the
several sub-reports, I am working on trying to get one report which covers
two different banks.

I still am unable to gain an ending balance.


However, I have gone back and corrected the errors in the sub-reports, I
think.

In the detail section, I have

Name: txtSumExpenses
Control Source: =IIf([SubRpt_Expenses_Yearly].[Report].[has
data],[SubRpt_Expenses_Yearly].[Report].[txtSumExpenses],0)


Name: txtSumIncome
Control Source: =IIf([SubRpt_Income_Yearly].[Report].[has
data],[SubRpt_Income_Yearly].[Report].[txtSumIncome],0)

No matter if I put the following in the Beginning Footer OR in the Report
Footer, I still do not, as stated above, get a Year End Sum.

Name: txtYrEndSum
Control Source: = Sum [TxtSumIncome]-[TxtSumExpense]

Also, I get #Name? error under each of the txtSumExpenses and txtSumIncome
Name and Control Source.

Duane, what oh what, am I NOT DOING correctly?

Christ's blessings,

Karen


:

Your expressions have lots of errors. Did you copy and paste these in your
message?
Try:
Name:txtSumExpenses
Control Source:=IIf([sub_report_expense_yearly].[report].[hasdata],
[sub_report_expense_yearly].Report.[txtExpenseSum],0)

Name:txtSumAssets
Control Source:=IIf([sub_report_income_yearly].report.[has data],
[sub_report_income_yearly].report.[txttotalassets],0])

If you need these values to display in another section (group or report
footer) you must reference the control name from the detail section:
Control Source: =txtSumExpenses
Control Source: =txtSumAssets

--
Duane Hookom
Microsoft Access MVP


:

Please forgive me if I am double posting, I do not mean to. I need help and
did not get a response to "Puzzling Problems" and it does not come up when I
check it, so I am not sure it posted.

I have tried over and over again, various combinations, names, and
placements within report and sub-report footers, etc. for these two problems,
but am unable to come up with the correct answer. I once again hope there is
someone out there who can help me.

I am trying to achieve the Yearly Bank Balance. I have, a report in which I
first have a Beginning Balance Bank Header, nothing is in it expcept the bank
name.

In the detail section, I have the beginning balance. [Abegbal] Added to that
detail section, I have sub_report_income_yearly in which I have a text box
with the name TxtTotalAssets and a Control Source of =[Abegbal]+[txtincsum].
I get the total I need when I run the report.

Also in the detail section, I have subrpt_expense_yearly. In this
sub-report, I have a total expense. Name [TxtExpenseSum] Control Source
=Sum([CkAmt]) Again, I get the total I need when I run the report.

When I first started a smaller version of this project, I was instructed to
put in the detail section: two text boxes, one containing
=iif([sub_report_expense_yearly].[report].[has
data].[sub_report_expense_yearly].[txtExpenseSum],0) and another with
=iif[sub_report_income_yearly].report.[has data].[txttotalassets],0])

To obtain the ending balance, I have placed the following in both the
bankfooter and in the report footer. In neither, do I get the result I
desire.

I seem to have two problems. The one stated aboveof not getting the desired
answer, but also the label to the txt box keeps yeilding the name
TxtExpenseSum rather than the name I gave to the result, TxtAEndBal.

In the Text Box, I have the Name TxtAEndBal and Control Source of
=([txttotalassets]-txtexpensesum.

I also know how to show a negative balance, in the event we ever have one.

I hope I have written my question so that you can understand it and I await
with a humble heart and mind, for help with this problem.

You all have been so great to help me out in the past, so I hope you can
help me with these problems.

Thank you and God Bless,

K

 

[znibk]

Duane,

Thanks for the instruction to copy and paste so the name will be exact. As
you can see from my posts, sometimes I have a lot of typos which I do not
realize are there because my brain is seeing the correct thing.

You are right, the [Forms]![FrmBBDate]![TxtStart] did not work for the
report. It gave me an error.

I also receive an error report if I try to use Between
[Forms]![FrmDATES]![TxtStart] And [Forms]![FrmDATES]![TxtEnd]

Another error I am still encountering is I still can not get a total in the
main report section. Of any of the following, Total Assets, Total Expenses,
and Ending Balance. I do have a total expenses within the
SubRpt_AExpense_Yearly, but as the beginning balance comes within the body of
the main report and the total income are within the SubRpt_AIncome_Yearly, I
do not know how to doanything expcept try and total those two items within
the main report, Rpt_FinancialStatement_Yearly.

I have tried to be as brief as possible, and thank God this report is no
longer than it is. Also, unless noted as not visible, the text boxes and
labels are visible.


The Main Report, Rpt_FinancialStatement_Yearly has
RS: Qry_ArvestBegBal
Field: ABegBalDate
Criteria: Between [Forms]![FrmDates]![TxtStart] And
[Forms]![FrmDates]![TxtEnd]

ABegBalDateHeader in which contains the following formula:
="Community Outreach Services, Inc. Financial Statement
for Period " & Forms!FrmDates!TxtStart & " Through " &
Forms!FrmDates!TxtEnd

In the Detail Section, I have Label:
Name: ArvestBegBalance
Caption: ARVEST Bank Beginning Bal:

Text Box:
Name: TxtABegBal
CS: [ABegBal]


Next: SubRpt_AIncome_Yearly is placed within the Detail Section of the Main
Report: Rpt_FinancialStatement_Yearly just after the ArvestBegBalance


SubRpt_AIncome_Yearly
Record Source: SumQry_AIncome_Yearly
In query,
Field Name: [IncDate]
Criteria: Between [Forms]![FrmDates]![TxtStart] And
[Forms]![FrmDates]![TxtEnd]



Report Header label “Incomeâ€
IncTypeHeader contains Field [IncType] (I have several different types of
income—this field is not visible.
Detail Section: Field [ATotInc] not visible

IncType Footer two text boxes
1) Text Box
Name: Income Type
CS: [IncType]

2) Text Box:
Name: TxtIncSum_
CS: =Sum([ATotInc])

Report Footer:
Lable, Name: Sub_Rpt_AIncome_Yearly.Report.TxtRunInc

Text Box:
Name: TxtRunInc
CS: =Sum([ATotInc])


When I run only the SubRpt_AIncome_Yearly, I get the correct income

Back to Main Report, Rpt_FinancialStatement_Yearly, In the Detail Section,
After the SubRpt_AIncome_Yearly, I have the following:

Label:
Name: TxtRunAssets

Text Box
Name: TxtRunAssets_
CS: =[ABegBal]+[TxtRunInc]

When I try to run the yearly report, to have a Total Assets Section, I get
#Error. I am still using the FrmDATES to enter the start and end dates,

And Duane, please do not ask me who it was that helped me about two years
ago to develop the initial monthly report and name my text boxes correctly,
because I do not remember. I just know he, at that time explained to me why I
needed to have The “Txt†or “Run†as part of the name in the text box. Would
please explain that to me again. I have forgotten.

After the Text Box in which I try to obtain my Total Assets, given below,
same as above, for refresher after the question about the “Txt†and “Runâ€

Text Box
Name: TxtRunAssets_
CS: =[ABegBal]+[TxtRunInc]

SubRpt_AExpense_Yearly

Report Header, blank

Whose Header
Txt Box:
Name: Whose
CS: [Whose] (listing the category in which the expense belongs) visible

Txt Box:
Name: Bank, Not visible
CS: [Bank] Not visible

Detail Section:
Text Box:
Name: Descriptions, Not visible
CS: [Description], Not visible and

Text Box:
Name: CkAmt, Not visible
CS: [CkAmt], Not visible

Description Footer:
Text Box:
Name: Descriptions,
CS: [Description],

Text Box:
Name: TotalCkAmt
CS: =Sum([CkAmt])

Whose Footer
Text Box:
Name: WhoesExpenseIsIt
CS: [="Total " & [Whoes] & " :"]

Text Box:
Name: ATotExpSum
CS: [=Sum([CkAmt])]


Report Footer
Text Box:
Label: Total Arvest Expenses
Name: TxtExpenseSum
CS: [=Sum([CkAmt])]

After the SubRpt_AExpenses_Yearly, I have tried leaving the Total Arvest
expenses out of the SubRpt_AExpenses_Yearly and putting the Text Box in the
Detail Section of the main report Rpt_FinancialStatement_Yearly, but I get an
error message each time.

Therefore, I have tried a combination of formulas in the Report Footer of
the Rpt_FinancialStatement_Yearly, I have yet to obtain anything except a
#Error message.

Currently,I have

Text Box:
Label: ArvestEndBalance
Name: AnEndingBalance
CS: =[TxtRunAssets]-[TxtRunExp]

Again, I tried to be as brief as possible. I hope I have recorded the things
you need and the information you have will be enough to answer my questions.
I still must do this for another bank in the same report.

May God truly bless you for your patience.

Karen

Please provide your background information in a reply. I don't recall your
report setup and what "wording and position" have to do with anything.

--
Duane Hookom
Microsoft Access MVP

Duane,

Finally getting back. I think I have that. However, when I use the "Between
[Forms]![FrmDATES]![TxtStart] And [Forms]![FrmDATES]![TxtEnd] I get about 27
pages of a report and the beginning balance, income, and expenses of each
month are included.

How can I just get the report to pull the beginning balance of the date I
give it, for example, 9/1/07.

FYI I have started writing the information of each subreport--the query,
text boxes, etc. but that is a lot of information and do not want to post it
unless absolutely necessary.

Thank you so much for you patience and help.

Karen

I doubt "[form]![BBDate]![txtStat]" will work since it should probably by
"[form]![BBDate]![txtStart]". Also in all cases, you should be using [Forms]
not [form]. Please copy and paste your expressions so the syntax matches your
actual and I can see the upper and lower case letters.

Here's what I know about retrieving values from a subreport into a main
report:

- A subreport is a control on your main report
- The subreport control has "Name" and "Source Object" properties
These are often the same value but might be different. When
they are different, you need to use the "Name" property, not the
"Source Object".
* assume the subreport control name is "srptOne"
- The typical setup has a text box in the report footer of the subreport
containing an aggregated value.
* assume this text box is "txtSumQty"
- You can add a text box on the main report in the same section as the
subreport with an expression like:
* assume this text box is "txtSumFromsrptOne"
=srptOne.Report.txtSumQty
- If your subreport might not return any records, you need to use
=IIf(srptOne.Report.HasData, srptOne.Report.txtSumQt, 0)
- If you want the value from the subreport to be displayed in a section
of the main report other than section containing the subreport:
- create txtSumFromsrptOne as above and
- add a text box in the other section with a control source of:
=txtSumFromsrptOne
--
Duane Hookom
Microsoft Access MVP


:

Duane,

Duane,

Do I feel like a GIANT DOOP, I fixed all the accidental errors in the
SubRpt_Expenses_Yearly but have not fixed them in the SubRpt_Income_Yearly.

I do have a question, I have called the total of all of my income,
txtincsum. I had planned to have:

Name: TxtTotalAssets
Control Source: [begbal]+[txtincsum]

is that okay or do I have to rename?

Also, I have several beginning balances in one query, so that I get the
correct beginning balance, I have under the date field,
[form]![BBDate]![txtStat] In the event that I do not ask for only one
beginning balance, I am concerned that the beginning balance from the query
at the first of each month will automatically figure into the total assets,
is that an uncessary concern?

then when I enter the rest of the information, for the income and for the
expenses, I have in the date field in the query Between
[form]![frmDATES]![txtstart] And [form]![frmDATES]![txtend], are those
parameters acceptable or do I need to do something else?

Please check my thread as it is midnight here and I do need to get some
sleep. I have an extremely long day tomorrow and will have to work this in
once I make my corrections in the SubRpt_Income_Yearly after checking your
response to these questions later this morning.

One other quick question--does it make any difference in what section of a
subreport or report that I put
Name: txtSumExpenses
Control Source: =IIf([SubRpt_Expenses_Yearly].[Report].[has
data],[SubRpt_Expenses_Yearly].[Report].[txtSumExpenses],0)

or the Name:txtSumIncome etc. and does the expense information need to be in
the SubReport or does the final Report just need to contain both sets of
information?

Thank you, Good night, and God bless,

Karen


:

If the two text boxes don't work, then attempting to subtract one from the
other won't work.
Are you using the name of the subreport controls or the name of the Source
Object? Do you know the difference?

I don't know why you would use Sum and then not have any ()s. If the text
boxes worked you would just use:

Control Source: =[TxtSumIncome]-[TxtSumExpense]
--
Duane Hookom
Microsoft Access MVP


:

Duane,

God bless you for helping, and you did help, we just aren't there yet. When
we get the two errors below corrected, I have another one I would like help
with, then again, who knows, I may have it correct, Miracles Happen ALL the
time.

To answer your question about the copy and paste, actually, I typed
everything and in my attempt to be careful, and the fact that I was
completely exhausted when I finally gave up all attempts and said “Karen, ask
for help.†Anyway, I succeeded in interchanging some of the names in the
several sub-reports, I am working on trying to get one report which covers
two different banks.

I still am unable to gain an ending balance.


However, I have gone back and corrected the errors in the sub-reports, I
think.

In the detail section, I have

Name: txtSumExpenses
Control Source: =IIf([SubRpt_Expenses_Yearly].[Report].[has
data],[SubRpt_Expenses_Yearly].[Report].[txtSumExpenses],0)


Name: txtSumIncome
Control Source: =IIf([SubRpt_Income_Yearly].[Report].[has
data],[SubRpt_Income_Yearly].[Report].[txtSumIncome],0)

No matter if I put the following in the Beginning Footer OR in the Report
Footer, I still do not, as stated above, get a Year End Sum.

Name: txtYrEndSum
Control Source: = Sum [TxtSumIncome]-[TxtSumExpense]

Also, I get #Name? error under each of the txtSumExpenses and txtSumIncome
Name and Control Source.

Duane, what oh what, am I NOT DOING correctly?

Christ's blessings,

Karen


:

Your expressions have lots of errors. Did you copy and paste these in your
message?
Try:
Name:txtSumExpenses
Control Source:=IIf([sub_report_expense_yearly].[report].[hasdata],
[sub_report_expense_yearly].Report.[txtExpenseSum],0)

Name:txtSumAssets
Control Source:=IIf([sub_report_income_yearly].report.[has data],
[sub_report_income_yearly].report.[txttotalassets],0])

If you need these values to display in another section (group or report
footer) you must reference the control name from the detail section:
Control Source: =txtSumExpenses
Control Source: =txtSumAssets

--
Duane Hookom
Microsoft Access MVP


:

Please forgive me if I am double posting, I do not mean to. I need help and
did not get a response to "Puzzling Problems" and it does not come up when I
check it, so I am not sure it posted.

I have tried over and over again, various combinations, names, and
placements within report and sub-report footers, etc. for these two problems,
but am unable to come up with the correct answer. I once again hope there is
someone out there who can help me.

I am trying to achieve the Yearly Bank Balance. I have, a report in which I
first have a Beginning Balance Bank Header, nothing is in it expcept the bank
name.

In the detail section, I have the beginning balance. [Abegbal] Added to that
detail section, I have sub_report_income_yearly in which I have a text box
with the name TxtTotalAssets and a Control Source of =[Abegbal]+[txtincsum].
I get the total I need when I run the report.

Also in the detail section, I have subrpt_expense_yearly. In this
sub-report, I have a total expense. Name [TxtExpenseSum] Control Source
=Sum([CkAmt]) Again, I get the total I need when I run the report.

When I first started a smaller version of this project, I was instructed to
put in the detail section: two text boxes, one containing
=iif([sub_report_expense_yearly].[report].[has
data].[sub_report_expense_yearly].[txtExpenseSum],0) and another with
=iif[sub_report_income_yearly].report.[has data].[txttotalassets],0])

To obtain the ending balance, I have placed the following in both the
bankfooter and in the report footer. In neither, do I get the result I
desire.

I seem to have two problems. The one stated aboveof not getting the desired
answer, but also the label to the txt box keeps yeilding the name
TxtExpenseSum rather than the name I gave to the result, TxtAEndBal.

In the Text Box, I have the Name TxtAEndBal and Control Source of
=([txttotalassets]-txtexpensesum.

I also know how to show a negative balance, in the event we ever have one.

I hope I have written my question so that you can understand it and I await
with a humble heart and mind, for help with this problem.

You all have been so great to help me out in the past, so I hope you can
help me with these problems.

Thank you and God Bless,

K

 

[Duane Hookom]

From your post, I don't see where you used anything like
=srptOne.Report.txtSumQty
which was from my earlier post. Did you read my post? Did you understand it?
If you want to reference a control from a subreport in a control on the main
report, your expression must be something like:
=srptOne.Report.txtSumQty

--
Duane Hookom
Microsoft Access MVP

Duane,

Thanks for the instruction to copy and paste so the name will be exact. As
you can see from my posts, sometimes I have a lot of typos which I do not
realize are there because my brain is seeing the correct thing.

You are right, the [Forms]![FrmBBDate]![TxtStart] did not work for the
report. It gave me an error.

I also receive an error report if I try to use Between
[Forms]![FrmDATES]![TxtStart] And [Forms]![FrmDATES]![TxtEnd]

Another error I am still encountering is I still can not get a total in the
main report section. Of any of the following, Total Assets, Total Expenses,
and Ending Balance. I do have a total expenses within the
SubRpt_AExpense_Yearly, but as the beginning balance comes within the body of
the main report and the total income are within the SubRpt_AIncome_Yearly, I
do not know how to doanything expcept try and total those two items within
the main report, Rpt_FinancialStatement_Yearly.

I have tried to be as brief as possible, and thank God this report is no
longer than it is. Also, unless noted as not visible, the text boxes and
labels are visible.


The Main Report, Rpt_FinancialStatement_Yearly has
RS: Qry_ArvestBegBal
Field: ABegBalDate
Criteria: Between [Forms]![FrmDates]![TxtStart] And
[Forms]![FrmDates]![TxtEnd]

ABegBalDateHeader in which contains the following formula:
="Community Outreach Services, Inc. Financial Statement
for Period " & Forms!FrmDates!TxtStart & " Through " &
Forms!FrmDates!TxtEnd

In the Detail Section, I have Label:
Name: ArvestBegBalance
Caption: ARVEST Bank Beginning Bal:

Text Box:
Name: TxtABegBal
CS: [ABegBal]


Next: SubRpt_AIncome_Yearly is placed within the Detail Section of the Main
Report: Rpt_FinancialStatement_Yearly just after the ArvestBegBalance


SubRpt_AIncome_Yearly
Record Source: SumQry_AIncome_Yearly
In query,
Field Name: [IncDate]
Criteria: Between [Forms]![FrmDates]![TxtStart] And
[Forms]![FrmDates]![TxtEnd]



Report Header label “Incomeâ€
IncTypeHeader contains Field [IncType] (I have several different types of
income—this field is not visible.
Detail Section: Field [ATotInc] not visible

IncType Footer two text boxes
1) Text Box
Name: Income Type
CS: [IncType]

2) Text Box:
Name: TxtIncSum_
CS: =Sum([ATotInc])

Report Footer:
Lable, Name: Sub_Rpt_AIncome_Yearly.Report.TxtRunInc

Text Box:
Name: TxtRunInc
CS: =Sum([ATotInc])


When I run only the SubRpt_AIncome_Yearly, I get the correct income

Back to Main Report, Rpt_FinancialStatement_Yearly, In the Detail Section,
After the SubRpt_AIncome_Yearly, I have the following:

Label:
Name: TxtRunAssets

Text Box
Name: TxtRunAssets_
CS: =[ABegBal]+[TxtRunInc]

When I try to run the yearly report, to have a Total Assets Section, I get
#Error. I am still using the FrmDATES to enter the start and end dates,

And Duane, please do not ask me who it was that helped me about two years
ago to develop the initial monthly report and name my text boxes correctly,
because I do not remember. I just know he, at that time explained to me why I
needed to have The “Txt†or “Run†as part of the name in the text box. Would
please explain that to me again. I have forgotten.

After the Text Box in which I try to obtain my Total Assets, given below,
same as above, for refresher after the question about the “Txt†and “Runâ€

Text Box
Name: TxtRunAssets_
CS: =[ABegBal]+[TxtRunInc]

SubRpt_AExpense_Yearly

Report Header, blank

Whose Header
Txt Box:
Name: Whose
CS: [Whose] (listing the category in which the expense belongs) visible

Txt Box:
Name: Bank, Not visible
CS: [Bank] Not visible

Detail Section:
Text Box:
Name: Descriptions, Not visible
CS: [Description], Not visible and

Text Box:
Name: CkAmt, Not visible
CS: [CkAmt], Not visible

Description Footer:
Text Box:
Name: Descriptions,
CS: [Description],

Text Box:
Name: TotalCkAmt
CS: =Sum([CkAmt])

Whose Footer
Text Box:
Name: WhoesExpenseIsIt
CS: [="Total " & [Whoes] & " :"]

Text Box:
Name: ATotExpSum
CS: [=Sum([CkAmt])]


Report Footer
Text Box:
Label: Total Arvest Expenses
Name: TxtExpenseSum
CS: [=Sum([CkAmt])]

After the SubRpt_AExpenses_Yearly, I have tried leaving the Total Arvest
expenses out of the SubRpt_AExpenses_Yearly and putting the Text Box in the
Detail Section of the main report Rpt_FinancialStatement_Yearly, but I get an
error message each time.

Therefore, I have tried a combination of formulas in the Report Footer of
the Rpt_FinancialStatement_Yearly, I have yet to obtain anything except a
#Error message.

Currently,I have

Text Box:
Label: ArvestEndBalance
Name: AnEndingBalance
CS: =[TxtRunAssets]-[TxtRunExp]

Again, I tried to be as brief as possible. I hope I have recorded the things
you need and the information you have will be enough to answer my questions.
I still must do this for another bank in the same report.

May God truly bless you for your patience.

Karen

Please provide your background information in a reply. I don't recall your
report setup and what "wording and position" have to do with anything.

--
Duane Hookom
Microsoft Access MVP

Duane,

Finally getting back. I think I have that. However, when I use the "Between
[Forms]![FrmDATES]![TxtStart] And [Forms]![FrmDATES]![TxtEnd] I get about 27
pages of a report and the beginning balance, income, and expenses of each
month are included.

How can I just get the report to pull the beginning balance of the date I
give it, for example, 9/1/07.

FYI I have started writing the information of each subreport--the query,
text boxes, etc. but that is a lot of information and do not want to post it
unless absolutely necessary.

Thank you so much for you patience and help.

Karen

:

I doubt "[form]![BBDate]![txtStat]" will work since it should probably by
"[form]![BBDate]![txtStart]". Also in all cases, you should be using [Forms]
not [form]. Please copy and paste your expressions so the syntax matches your
actual and I can see the upper and lower case letters.

Here's what I know about retrieving values from a subreport into a main
report:

- A subreport is a control on your main report
- The subreport control has "Name" and "Source Object" properties
These are often the same value but might be different. When
they are different, you need to use the "Name" property, not the
"Source Object".
* assume the subreport control name is "srptOne"
- The typical setup has a text box in the report footer of the subreport
containing an aggregated value.
* assume this text box is "txtSumQty"
- You can add a text box on the main report in the same section as the
subreport with an expression like:
* assume this text box is "txtSumFromsrptOne"
=srptOne.Report.txtSumQty
- If your subreport might not return any records, you need to use
=IIf(srptOne.Report.HasData, srptOne.Report.txtSumQt, 0)
- If you want the value from the subreport to be displayed in a section
of the main report other than section containing the subreport:
- create txtSumFromsrptOne as above and
- add a text box in the other section with a control source of:
=txtSumFromsrptOne
--
Duane Hookom
Microsoft Access MVP


:

Duane,

Duane,

Do I feel like a GIANT DOOP, I fixed all the accidental errors in the
SubRpt_Expenses_Yearly but have not fixed them in the SubRpt_Income_Yearly.

I do have a question, I have called the total of all of my income,
txtincsum. I had planned to have:

Name: TxtTotalAssets
Control Source: [begbal]+[txtincsum]

is that okay or do I have to rename?

Also, I have several beginning balances in one query, so that I get the
correct beginning balance, I have under the date field,
[form]![BBDate]![txtStat] In the event that I do not ask for only one
beginning balance, I am concerned that the beginning balance from the query
at the first of each month will automatically figure into the total assets,
is that an uncessary concern?

then when I enter the rest of the information, for the income and for the
expenses, I have in the date field in the query Between
[form]![frmDATES]![txtstart] And [form]![frmDATES]![txtend], are those
parameters acceptable or do I need to do something else?

Please check my thread as it is midnight here and I do need to get some
sleep. I have an extremely long day tomorrow and will have to work this in
once I make my corrections in the SubRpt_Income_Yearly after checking your
response to these questions later this morning.

One other quick question--does it make any difference in what section of a
subreport or report that I put
Name: txtSumExpenses
Control Source: =IIf([SubRpt_Expenses_Yearly].[Report].[has
data],[SubRpt_Expenses_Yearly].[Report].[txtSumExpenses],0)

or the Name:txtSumIncome etc. and does the expense information need to be in
the SubReport or does the final Report just need to contain both sets of
information?

Thank you, Good night, and God bless,

Karen


:

If the two text boxes don't work, then attempting to subtract one from the
other won't work.
Are you using the name of the subreport controls or the name of the Source
Object? Do you know the difference?

 

[znibk]

Duane,

Yes, I read and tried your =srptOne.Report.txtSumQty
-srptTwo.ReportTxtSumExpense

When I tried to run the report, it asks me for those two things. That
indicates I have not put them in the correct places, I think, so, where
exactly do I need to place them?

From your post, I don't see where you used anything like
=srptOne.Report.txtSumQty
which was from my earlier post. Did you read my post? Did you understand it?
If you want to reference a control from a subreport in a control on the main
report, your expression must be something like:
=srptOne.Report.txtSumQty

--
Duane Hookom
Microsoft Access MVP

Duane,

Thanks for the instruction to copy and paste so the name will be exact. As
you can see from my posts, sometimes I have a lot of typos which I do not
realize are there because my brain is seeing the correct thing.

You are right, the [Forms]![FrmBBDate]![TxtStart] did not work for the
report. It gave me an error.

I also receive an error report if I try to use Between
[Forms]![FrmDATES]![TxtStart] And [Forms]![FrmDATES]![TxtEnd]

Another error I am still encountering is I still can not get a total in the
main report section. Of any of the following, Total Assets, Total Expenses,
and Ending Balance. I do have a total expenses within the
SubRpt_AExpense_Yearly, but as the beginning balance comes within the body of
the main report and the total income are within the SubRpt_AIncome_Yearly, I
do not know how to doanything expcept try and total those two items within
the main report, Rpt_FinancialStatement_Yearly.

I have tried to be as brief as possible, and thank God this report is no
longer than it is. Also, unless noted as not visible, the text boxes and
labels are visible.


The Main Report, Rpt_FinancialStatement_Yearly has
RS: Qry_ArvestBegBal
Field: ABegBalDate
Criteria: Between [Forms]![FrmDates]![TxtStart] And
[Forms]![FrmDates]![TxtEnd]

ABegBalDateHeader in which contains the following formula:
="Community Outreach Services, Inc. Financial Statement
for Period " & Forms!FrmDates!TxtStart & " Through " &
Forms!FrmDates!TxtEnd

In the Detail Section, I have Label:
Name: ArvestBegBalance
Caption: ARVEST Bank Beginning Bal:

Text Box:
Name: TxtABegBal
CS: [ABegBal]


Next: SubRpt_AIncome_Yearly is placed within the Detail Section of the Main
Report: Rpt_FinancialStatement_Yearly just after the ArvestBegBalance


SubRpt_AIncome_Yearly
Record Source: SumQry_AIncome_Yearly
In query,
Field Name: [IncDate]
Criteria: Between [Forms]![FrmDates]![TxtStart] And
[Forms]![FrmDates]![TxtEnd]



Report Header label “Incomeâ€
IncTypeHeader contains Field [IncType] (I have several different types of
income—this field is not visible.
Detail Section: Field [ATotInc] not visible

IncType Footer two text boxes
1) Text Box
Name: Income Type
CS: [IncType]

2) Text Box:
Name: TxtIncSum_
CS: =Sum([ATotInc])

Report Footer:
Lable, Name: Sub_Rpt_AIncome_Yearly.Report.TxtRunInc

Text Box:
Name: TxtRunInc
CS: =Sum([ATotInc])


When I run only the SubRpt_AIncome_Yearly, I get the correct income

Back to Main Report, Rpt_FinancialStatement_Yearly, In the Detail Section,
After the SubRpt_AIncome_Yearly, I have the following:

Label:
Name: TxtRunAssets

Text Box
Name: TxtRunAssets_
CS: =[ABegBal]+[TxtRunInc]

When I try to run the yearly report, to have a Total Assets Section, I get
#Error. I am still using the FrmDATES to enter the start and end dates,

And Duane, please do not ask me who it was that helped me about two years
ago to develop the initial monthly report and name my text boxes correctly,
because I do not remember. I just know he, at that time explained to me why I
needed to have The “Txt†or “Run†as part of the name in the text box. Would
please explain that to me again. I have forgotten.

After the Text Box in which I try to obtain my Total Assets, given below,
same as above, for refresher after the question about the “Txt†and “Runâ€

Text Box
Name: TxtRunAssets_
CS: =[ABegBal]+[TxtRunInc]

SubRpt_AExpense_Yearly

Report Header, blank

Whose Header
Txt Box:
Name: Whose
CS: [Whose] (listing the category in which the expense belongs) visible

Txt Box:
Name: Bank, Not visible
CS: [Bank] Not visible

Detail Section:
Text Box:
Name: Descriptions, Not visible
CS: [Description], Not visible and

Text Box:
Name: CkAmt, Not visible
CS: [CkAmt], Not visible

Description Footer:
Text Box:
Name: Descriptions,
CS: [Description],

Text Box:
Name: TotalCkAmt
CS: =Sum([CkAmt])

Whose Footer
Text Box:
Name: WhoesExpenseIsIt
CS: [="Total " & [Whoes] & " :"]

Text Box:
Name: ATotExpSum
CS: [=Sum([CkAmt])]


Report Footer
Text Box:
Label: Total Arvest Expenses
Name: TxtExpenseSum
CS: [=Sum([CkAmt])]

After the SubRpt_AExpenses_Yearly, I have tried leaving the Total Arvest
expenses out of the SubRpt_AExpenses_Yearly and putting the Text Box in the
Detail Section of the main report Rpt_FinancialStatement_Yearly, but I get an
error message each time.

Therefore, I have tried a combination of formulas in the Report Footer of
the Rpt_FinancialStatement_Yearly, I have yet to obtain anything except a
#Error message.

Currently,I have

Text Box:
Label: ArvestEndBalance
Name: AnEndingBalance
CS: =[TxtRunAssets]-[TxtRunExp]

Again, I tried to be as brief as possible. I hope I have recorded the things
you need and the information you have will be enough to answer my questions.
I still must do this for another bank in the same report.

May God truly bless you for your patience.

Karen

Please provide your background information in a reply. I don't recall your
report setup and what "wording and position" have to do with anything.

--
Duane Hookom
Microsoft Access MVP


:

Duane,

Finally getting back. I think I have that. However, when I use the "Between
[Forms]![FrmDATES]![TxtStart] And [Forms]![FrmDATES]![TxtEnd] I get about 27
pages of a report and the beginning balance, income, and expenses of each
month are included.

How can I just get the report to pull the beginning balance of the date I
give it, for example, 9/1/07.

FYI I have started writing the information of each subreport--the query,
text boxes, etc. but that is a lot of information and do not want to post it
unless absolutely necessary.

Thank you so much for you patience and help.

Karen

:

I doubt "[form]![BBDate]![txtStat]" will work since it should probably by
"[form]![BBDate]![txtStart]". Also in all cases, you should be using [Forms]
not [form]. Please copy and paste your expressions so the syntax matches your
actual and I can see the upper and lower case letters.

Here's what I know about retrieving values from a subreport into a main
report:

- A subreport is a control on your main report
- The subreport control has "Name" and "Source Object" properties
These are often the same value but might be different. When
they are different, you need to use the "Name" property, not the
"Source Object".
* assume the subreport control name is "srptOne"
- The typical setup has a text box in the report footer of the subreport
containing an aggregated value.
* assume this text box is "txtSumQty"
- You can add a text box on the main report in the same section as the
subreport with an expression like:
* assume this text box is "txtSumFromsrptOne"
=srptOne.Report.txtSumQty
- If your subreport might not return any records, you need to use
=IIf(srptOne.Report.HasData, srptOne.Report.txtSumQt, 0)
- If you want the value from the subreport to be displayed in a section
of the main report other than section containing the subreport:
- create txtSumFromsrptOne as above and
- add a text box in the other section with a control source of:
=txtSumFromsrptOne
--
Duane Hookom
Microsoft Access MVP


:

Duane,

Duane,

Do I feel like a GIANT DOOP, I fixed all the accidental errors in the
SubRpt_Expenses_Yearly but have not fixed them in the SubRpt_Income_Yearly.

I do have a question, I have called the total of all of my income,
txtincsum. I had planned to have:

Name: TxtTotalAssets
Control Source: [begbal]+[txtincsum]

is that okay or do I have to rename?

Also, I have several beginning balances in one query, so that I get the
correct beginning balance, I have under the date field,
[form]![BBDate]![txtStat] In the event that I do not ask for only one
beginning balance, I am concerned that the beginning balance from the query
at the first of each month will automatically figure into the total assets,
is that an uncessary concern?

then when I enter the rest of the information, for the income and for the
expenses, I have in the date field in the query Between
[form]![frmDATES]![txtstart] And [form]![frmDATES]![txtend], are those
parameters acceptable or do I need to do something else?

Please check my thread as it is midnight here and I do need to get some
sleep. I have an extremely long day tomorrow and will have to work this in
once I make my corrections in the SubRpt_Income_Yearly after checking your
response to these questions later this morning.

One other quick question--does it make any difference in what section of a
subreport or report that I put
Name: txtSumExpenses
Control Source: =IIf([SubRpt_Expenses_Yearly].[Report].[has
data],[SubRpt_Expenses_Yearly].[Report].[txtSumExpenses],0)

or the Name:txtSumIncome etc. and does the expense information need to be in

 

[Duane Hookom]

These controls must be in the same section of the report as the subreport.
From my earlier reply:
- You can add a text box on the main report in the same section as the
subreport with an expression like:
* assume this text box is "txtSumFromsrptOne"
=srptOne.Report.txtSumQty

--
Duane Hookom
Microsoft Access MVP

Duane,

Yes, I read and tried your =srptOne.Report.txtSumQty
-srptTwo.ReportTxtSumExpense

When I tried to run the report, it asks me for those two things. That
indicates I have not put them in the correct places, I think, so, where
exactly do I need to place them?

From your post, I don't see where you used anything like
=srptOne.Report.txtSumQty
which was from my earlier post. Did you read my post? Did you understand it?
If you want to reference a control from a subreport in a control on the main
report, your expression must be something like:
=srptOne.Report.txtSumQty

--
Duane Hookom
Microsoft Access MVP

Duane,

Thanks for the instruction to copy and paste so the name will be exact. As
you can see from my posts, sometimes I have a lot of typos which I do not
realize are there because my brain is seeing the correct thing.

You are right, the [Forms]![FrmBBDate]![TxtStart] did not work for the
report. It gave me an error.

I also receive an error report if I try to use Between
[Forms]![FrmDATES]![TxtStart] And [Forms]![FrmDATES]![TxtEnd]

Another error I am still encountering is I still can not get a total in the
main report section. Of any of the following, Total Assets, Total Expenses,
and Ending Balance. I do have a total expenses within the
SubRpt_AExpense_Yearly, but as the beginning balance comes within the body of
the main report and the total income are within the SubRpt_AIncome_Yearly, I
do not know how to doanything expcept try and total those two items within
the main report, Rpt_FinancialStatement_Yearly.

I have tried to be as brief as possible, and thank God this report is no
longer than it is. Also, unless noted as not visible, the text boxes and
labels are visible.


The Main Report, Rpt_FinancialStatement_Yearly has
RS: Qry_ArvestBegBal
Field: ABegBalDate
Criteria: Between [Forms]![FrmDates]![TxtStart] And
[Forms]![FrmDates]![TxtEnd]

ABegBalDateHeader in which contains the following formula:
="Community Outreach Services, Inc. Financial Statement
for Period " & Forms!FrmDates!TxtStart & " Through " &
Forms!FrmDates!TxtEnd

In the Detail Section, I have Label:
Name: ArvestBegBalance
Caption: ARVEST Bank Beginning Bal:

Text Box:
Name: TxtABegBal
CS: [ABegBal]


Next: SubRpt_AIncome_Yearly is placed within the Detail Section of the Main
Report: Rpt_FinancialStatement_Yearly just after the ArvestBegBalance


SubRpt_AIncome_Yearly
Record Source: SumQry_AIncome_Yearly
In query,
Field Name: [IncDate]
Criteria: Between [Forms]![FrmDates]![TxtStart] And
[Forms]![FrmDates]![TxtEnd]



Report Header label “Incomeâ€
IncTypeHeader contains Field [IncType] (I have several different types of
income—this field is not visible.
Detail Section: Field [ATotInc] not visible

IncType Footer two text boxes
1) Text Box
Name: Income Type
CS: [IncType]

2) Text Box:
Name: TxtIncSum_
CS: =Sum([ATotInc])

Report Footer:
Lable, Name: Sub_Rpt_AIncome_Yearly.Report.TxtRunInc

Text Box:
Name: TxtRunInc
CS: =Sum([ATotInc])


When I run only the SubRpt_AIncome_Yearly, I get the correct income

Back to Main Report, Rpt_FinancialStatement_Yearly, In the Detail Section,
After the SubRpt_AIncome_Yearly, I have the following:

Label:
Name: TxtRunAssets

Text Box
Name: TxtRunAssets_
CS: =[ABegBal]+[TxtRunInc]

When I try to run the yearly report, to have a Total Assets Section, I get
#Error. I am still using the FrmDATES to enter the start and end dates,

And Duane, please do not ask me who it was that helped me about two years
ago to develop the initial monthly report and name my text boxes correctly,
because I do not remember. I just know he, at that time explained to me why I
needed to have The “Txt†or “Run†as part of the name in the text box. Would
please explain that to me again. I have forgotten.

After the Text Box in which I try to obtain my Total Assets, given below,
same as above, for refresher after the question about the “Txt†and “Runâ€

Text Box
Name: TxtRunAssets_
CS: =[ABegBal]+[TxtRunInc]

SubRpt_AExpense_Yearly

Report Header, blank

Whose Header
Txt Box:
Name: Whose
CS: [Whose] (listing the category in which the expense belongs) visible

Txt Box:
Name: Bank, Not visible
CS: [Bank] Not visible

Detail Section:
Text Box:
Name: Descriptions, Not visible
CS: [Description], Not visible and

Text Box:
Name: CkAmt, Not visible
CS: [CkAmt], Not visible

Description Footer:
Text Box:
Name: Descriptions,
CS: [Description],

Text Box:
Name: TotalCkAmt
CS: =Sum([CkAmt])

Whose Footer
Text Box:
Name: WhoesExpenseIsIt
CS: [="Total " & [Whoes] & " :"]

Text Box:
Name: ATotExpSum
CS: [=Sum([CkAmt])]


Report Footer
Text Box:
Label: Total Arvest Expenses
Name: TxtExpenseSum
CS: [=Sum([CkAmt])]

After the SubRpt_AExpenses_Yearly, I have tried leaving the Total Arvest
expenses out of the SubRpt_AExpenses_Yearly and putting the Text Box in the
Detail Section of the main report Rpt_FinancialStatement_Yearly, but I get an
error message each time.

Therefore, I have tried a combination of formulas in the Report Footer of
the Rpt_FinancialStatement_Yearly, I have yet to obtain anything except a
#Error message.

Currently,I have

Text Box:
Label: ArvestEndBalance
Name: AnEndingBalance
CS: =[TxtRunAssets]-[TxtRunExp]

Again, I tried to be as brief as possible. I hope I have recorded the things
you need and the information you have will be enough to answer my questions.
I still must do this for another bank in the same report.

May God truly bless you for your patience.

Karen


:

Please provide your background information in a reply. I don't recall your
report setup and what "wording and position" have to do with anything.

--
Duane Hookom
Microsoft Access MVP


:

Duane,

Finally getting back. I think I have that. However, when I use the "Between
[Forms]![FrmDATES]![TxtStart] And [Forms]![FrmDATES]![TxtEnd] I get about 27
pages of a report and the beginning balance, income, and expenses of each
month are included.

How can I just get the report to pull the beginning balance of the date I
give it, for example, 9/1/07.

FYI I have started writing the information of each subreport--the query,
text boxes, etc. but that is a lot of information and do not want to post it
unless absolutely necessary.

Thank you so much for you patience and help.

Karen

:

I doubt "[form]![BBDate]![txtStat]" will work since it should probably by
"[form]![BBDate]![txtStart]". Also in all cases, you should be using [Forms]
not [form]. Please copy and paste your expressions so the syntax matches your
actual and I can see the upper and lower case letters.

Here's what I know about retrieving values from a subreport into a main
report:

- A subreport is a control on your main report
- The subreport control has "Name" and "Source Object" properties
These are often the same value but might be different. When
they are different, you need to use the "Name" property, not the
"Source Object".
* assume the subreport control name is "srptOne"
- The typical setup has a text box in the report footer of the subreport
containing an aggregated value.
* assume this text box is "txtSumQty"
- You can add a text box on the main report in the same section as the
subreport with an expression like:
* assume this text box is "txtSumFromsrptOne"
=srptOne.Report.txtSumQty
- If your subreport might not return any records, you need to use
=IIf(srptOne.Report.HasData, srptOne.Report.txtSumQt, 0)
- If you want the value from the subreport to be displayed in a section
of the main report other than section containing the subreport:
- create txtSumFromsrptOne as above and
- add a text box in the other section with a control source of:
=txtSumFromsrptOne
--
Duane Hookom
Microsoft Access MVP


:

Duane,

Duane,

Do I feel like a GIANT DOOP, I fixed all the accidental errors in the
SubRpt_Expenses_Yearly but have not fixed them in the SubRpt_Income_Yearly.

I do have a question, I have called the total of all of my income,
txtincsum. I had planned to have:

Name: TxtTotalAssets
Control Source: [begbal]+[txtincsum]

is that okay or do I have to rename?

Also, I have several beginning balances in one query, so that I get the
correct beginning balance, I have under the date field,
[form]![BBDate]![txtStat] In the event that I do not ask for only one
beginning balance, I am concerned that the beginning balance from the query
at the first of each month will automatically figure into the total assets,
is that an uncessary concern?

then when I enter the rest of the information, for the income and for the
expenses, I have in the date field in the query Between
[form]![frmDATES]![txtstart] And [form]![frmDATES]![txtend], are those
parameters acceptable or do I need to do something else?

Please check my thread as it is midnight here and I do need to get some

 

[znibk]

Duane,

I did put those expressions in the main report to which I added my subreports.

I went back and entered

"txtSumFromsrptOne"

=srptOne.Report.txtSumQty and also

"txtRunIncFromSubRpt_AIncome_Yearly"
=SubRpt_AIncome_Yearly.Report.txtRunInc,0

With both, I get the message that there is no field name and invalid control
source.

What am I doing wrong??????????????????????

Karen

These controls must be in the same section of the report as the subreport.
From my earlier reply:
- You can add a text box on the main report in the same section as the
subreport with an expression like:
* assume this text box is "txtSumFromsrptOne"
=srptOne.Report.txtSumQty

--
Duane Hookom
Microsoft Access MVP

Duane,

Yes, I read and tried your =srptOne.Report.txtSumQty
-srptTwo.ReportTxtSumExpense

When I tried to run the report, it asks me for those two things. That
indicates I have not put them in the correct places, I think, so, where
exactly do I need to place them?

From your post, I don't see where you used anything like
=srptOne.Report.txtSumQty
which was from my earlier post. Did you read my post? Did you understand it?
If you want to reference a control from a subreport in a control on the main
report, your expression must be something like:
=srptOne.Report.txtSumQty

--
Duane Hookom
Microsoft Access MVP


:

Duane,

Thanks for the instruction to copy and paste so the name will be exact. As
you can see from my posts, sometimes I have a lot of typos which I do not
realize are there because my brain is seeing the correct thing.

You are right, the [Forms]![FrmBBDate]![TxtStart] did not work for the
report. It gave me an error.

I also receive an error report if I try to use Between
[Forms]![FrmDATES]![TxtStart] And [Forms]![FrmDATES]![TxtEnd]

Another error I am still encountering is I still can not get a total in the
main report section. Of any of the following, Total Assets, Total Expenses,
and Ending Balance. I do have a total expenses within the
SubRpt_AExpense_Yearly, but as the beginning balance comes within the body of
the main report and the total income are within the SubRpt_AIncome_Yearly, I
do not know how to doanything expcept try and total those two items within
the main report, Rpt_FinancialStatement_Yearly.

I have tried to be as brief as possible, and thank God this report is no
longer than it is. Also, unless noted as not visible, the text boxes and
labels are visible.


The Main Report, Rpt_FinancialStatement_Yearly has
RS: Qry_ArvestBegBal
Field: ABegBalDate
Criteria: Between [Forms]![FrmDates]![TxtStart] And
[Forms]![FrmDates]![TxtEnd]

ABegBalDateHeader in which contains the following formula:
="Community Outreach Services, Inc. Financial Statement
for Period " & Forms!FrmDates!TxtStart & " Through " &
Forms!FrmDates!TxtEnd

In the Detail Section, I have Label:
Name: ArvestBegBalance
Caption: ARVEST Bank Beginning Bal:

Text Box:
Name: TxtABegBal
CS: [ABegBal]


Next: SubRpt_AIncome_Yearly is placed within the Detail Section of the Main
Report: Rpt_FinancialStatement_Yearly just after the ArvestBegBalance


SubRpt_AIncome_Yearly
Record Source: SumQry_AIncome_Yearly
In query,
Field Name: [IncDate]
Criteria: Between [Forms]![FrmDates]![TxtStart] And
[Forms]![FrmDates]![TxtEnd]



Report Header label “Incomeâ€
IncTypeHeader contains Field [IncType] (I have several different types of
income—this field is not visible.
Detail Section: Field [ATotInc] not visible

IncType Footer two text boxes
1) Text Box
Name: Income Type
CS: [IncType]

2) Text Box:
Name: TxtIncSum_
CS: =Sum([ATotInc])

Report Footer:
Lable, Name: Sub_Rpt_AIncome_Yearly.Report.TxtRunInc

Text Box:
Name: TxtRunInc
CS: =Sum([ATotInc])


When I run only the SubRpt_AIncome_Yearly, I get the correct income

Back to Main Report, Rpt_FinancialStatement_Yearly, In the Detail Section,
After the SubRpt_AIncome_Yearly, I have the following:

Label:
Name: TxtRunAssets

Text Box
Name: TxtRunAssets_
CS: =[ABegBal]+[TxtRunInc]

When I try to run the yearly report, to have a Total Assets Section, I get
#Error. I am still using the FrmDATES to enter the start and end dates,

And Duane, please do not ask me who it was that helped me about two years
ago to develop the initial monthly report and name my text boxes correctly,
because I do not remember. I just know he, at that time explained to me why I
needed to have The “Txt†or “Run†as part of the name in the text box. Would
please explain that to me again. I have forgotten.

After the Text Box in which I try to obtain my Total Assets, given below,
same as above, for refresher after the question about the “Txt†and “Runâ€

Text Box
Name: TxtRunAssets_
CS: =[ABegBal]+[TxtRunInc]

SubRpt_AExpense_Yearly

Report Header, blank

Whose Header
Txt Box:
Name: Whose
CS: [Whose] (listing the category in which the expense belongs) visible

Txt Box:
Name: Bank, Not visible
CS: [Bank] Not visible

Detail Section:
Text Box:
Name: Descriptions, Not visible
CS: [Description], Not visible and

Text Box:
Name: CkAmt, Not visible
CS: [CkAmt], Not visible

Description Footer:
Text Box:
Name: Descriptions,
CS: [Description],

Text Box:
Name: TotalCkAmt
CS: =Sum([CkAmt])

Whose Footer
Text Box:
Name: WhoesExpenseIsIt
CS: [="Total " & [Whoes] & " :"]

Text Box:
Name: ATotExpSum
CS: [=Sum([CkAmt])]


Report Footer
Text Box:
Label: Total Arvest Expenses
Name: TxtExpenseSum
CS: [=Sum([CkAmt])]

After the SubRpt_AExpenses_Yearly, I have tried leaving the Total Arvest
expenses out of the SubRpt_AExpenses_Yearly and putting the Text Box in the
Detail Section of the main report Rpt_FinancialStatement_Yearly, but I get an
error message each time.

Therefore, I have tried a combination of formulas in the Report Footer of
the Rpt_FinancialStatement_Yearly, I have yet to obtain anything except a
#Error message.

Currently,I have

Text Box:
Label: ArvestEndBalance
Name: AnEndingBalance
CS: =[TxtRunAssets]-[TxtRunExp]

Again, I tried to be as brief as possible. I hope I have recorded the things
you need and the information you have will be enough to answer my questions.
I still must do this for another bank in the same report.

May God truly bless you for your patience.

Karen


:

Please provide your background information in a reply. I don't recall your
report setup and what "wording and position" have to do with anything.

--
Duane Hookom
Microsoft Access MVP


:

Duane,

Finally getting back. I think I have that. However, when I use the "Between
[Forms]![FrmDATES]![TxtStart] And [Forms]![FrmDATES]![TxtEnd] I get about 27
pages of a report and the beginning balance, income, and expenses of each
month are included.

How can I just get the report to pull the beginning balance of the date I
give it, for example, 9/1/07.

FYI I have started writing the information of each subreport--the query,
text boxes, etc. but that is a lot of information and do not want to post it
unless absolutely necessary.

Thank you so much for you patience and help.

Karen

:

I doubt "[form]![BBDate]![txtStat]" will work since it should probably by
"[form]![BBDate]![txtStart]". Also in all cases, you should be using [Forms]
not [form]. Please copy and paste your expressions so the syntax matches your
actual and I can see the upper and lower case letters.

Here's what I know about retrieving values from a subreport into a main
report:

- A subreport is a control on your main report
- The subreport control has "Name" and "Source Object" properties
These are often the same value but might be different. When
they are different, you need to use the "Name" property, not the
"Source Object".
* assume the subreport control name is "srptOne"
- The typical setup has a text box in the report footer of the subreport
containing an aggregated value.
* assume this text box is "txtSumQty"
- You can add a text box on the main report in the same section as the
subreport with an expression like:
* assume this text box is "txtSumFromsrptOne"
=srptOne.Report.txtSumQty
- If your subreport might not return any records, you need to use
=IIf(srptOne.Report.HasData, srptOne.Report.txtSumQt, 0)
- If you want the value from the subreport to be displayed in a section
of the main report other than section containing the subreport:
- create txtSumFromsrptOne as above and
- add a text box in the other section with a control source of:
=txtSumFromsrptOne
--
Duane Hookom
Microsoft Access MVP


:

Duane,

Duane,

Do I feel like a GIANT DOOP, I fixed all the accidental errors in the
SubRpt_Expenses_Yearly but have not fixed them in the SubRpt_Income_Yearly.

I do have a question, I have called the total of all of my income,
txtincsum. I had planned to have:

Name: TxtTotalAssets
Control Source: [begbal]+[txtincsum]

is that okay or do I have to rename?

 

[Duane Hookom]

You just replied without using the word "section". I don't know if you
understand what I have been trying to explain since I can't see your report.
You do you have ",0" in your control source? I don't recall suggesting
anything like that?

--
Duane Hookom
Microsoft Access MVP

Duane,

I did put those expressions in the main report to which I added my subreports.

I went back and entered

"txtSumFromsrptOne"

=srptOne.Report.txtSumQty and also

"txtRunIncFromSubRpt_AIncome_Yearly"
=SubRpt_AIncome_Yearly.Report.txtRunInc,0

With both, I get the message that there is no field name and invalid control
source.

What am I doing wrong??????????????????????

Karen

These controls must be in the same section of the report as the subreport.
From my earlier reply:
- You can add a text box on the main report in the same section as the
subreport with an expression like:
* assume this text box is "txtSumFromsrptOne"
=srptOne.Report.txtSumQty

--
Duane Hookom
Microsoft Access MVP

Duane,

Yes, I read and tried your =srptOne.Report.txtSumQty
-srptTwo.ReportTxtSumExpense

When I tried to run the report, it asks me for those two things. That
indicates I have not put them in the correct places, I think, so, where
exactly do I need to place them?

:

From your post, I don't see where you used anything like
=srptOne.Report.txtSumQty
which was from my earlier post. Did you read my post? Did you understand it?
If you want to reference a control from a subreport in a control on the main
report, your expression must be something like:
=srptOne.Report.txtSumQty

--
Duane Hookom
Microsoft Access MVP


:

Duane,

Thanks for the instruction to copy and paste so the name will be exact. As
you can see from my posts, sometimes I have a lot of typos which I do not
realize are there because my brain is seeing the correct thing.

You are right, the [Forms]![FrmBBDate]![TxtStart] did not work for the
report. It gave me an error.

I also receive an error report if I try to use Between
[Forms]![FrmDATES]![TxtStart] And [Forms]![FrmDATES]![TxtEnd]

Another error I am still encountering is I still can not get a total in the
main report section. Of any of the following, Total Assets, Total Expenses,
and Ending Balance. I do have a total expenses within the
SubRpt_AExpense_Yearly, but as the beginning balance comes within the body of
the main report and the total income are within the SubRpt_AIncome_Yearly, I
do not know how to doanything expcept try and total those two items within
the main report, Rpt_FinancialStatement_Yearly.

I have tried to be as brief as possible, and thank God this report is no
longer than it is. Also, unless noted as not visible, the text boxes and
labels are visible.


The Main Report, Rpt_FinancialStatement_Yearly has
RS: Qry_ArvestBegBal
Field: ABegBalDate
Criteria: Between [Forms]![FrmDates]![TxtStart] And
[Forms]![FrmDates]![TxtEnd]

ABegBalDateHeader in which contains the following formula:
="Community Outreach Services, Inc. Financial Statement
for Period " & Forms!FrmDates!TxtStart & " Through " &
Forms!FrmDates!TxtEnd

In the Detail Section, I have Label:
Name: ArvestBegBalance
Caption: ARVEST Bank Beginning Bal:

Text Box:
Name: TxtABegBal
CS: [ABegBal]


Next: SubRpt_AIncome_Yearly is placed within the Detail Section of the Main
Report: Rpt_FinancialStatement_Yearly just after the ArvestBegBalance


SubRpt_AIncome_Yearly
Record Source: SumQry_AIncome_Yearly
In query,
Field Name: [IncDate]
Criteria: Between [Forms]![FrmDates]![TxtStart] And
[Forms]![FrmDates]![TxtEnd]



Report Header label “Incomeâ€
IncTypeHeader contains Field [IncType] (I have several different types of
income—this field is not visible.
Detail Section: Field [ATotInc] not visible

IncType Footer two text boxes
1) Text Box
Name: Income Type
CS: [IncType]

2) Text Box:
Name: TxtIncSum_
CS: =Sum([ATotInc])

Report Footer:
Lable, Name: Sub_Rpt_AIncome_Yearly.Report.TxtRunInc

Text Box:
Name: TxtRunInc
CS: =Sum([ATotInc])


When I run only the SubRpt_AIncome_Yearly, I get the correct income

Back to Main Report, Rpt_FinancialStatement_Yearly, In the Detail Section,
After the SubRpt_AIncome_Yearly, I have the following:

Label:
Name: TxtRunAssets

Text Box
Name: TxtRunAssets_
CS: =[ABegBal]+[TxtRunInc]

When I try to run the yearly report, to have a Total Assets Section, I get
#Error. I am still using the FrmDATES to enter the start and end dates,

And Duane, please do not ask me who it was that helped me about two years
ago to develop the initial monthly report and name my text boxes correctly,
because I do not remember. I just know he, at that time explained to me why I
needed to have The “Txt†or “Run†as part of the name in the text box. Would
please explain that to me again. I have forgotten.

After the Text Box in which I try to obtain my Total Assets, given below,
same as above, for refresher after the question about the “Txt†and “Runâ€

Text Box
Name: TxtRunAssets_
CS: =[ABegBal]+[TxtRunInc]

SubRpt_AExpense_Yearly

Report Header, blank

Whose Header
Txt Box:
Name: Whose
CS: [Whose] (listing the category in which the expense belongs) visible

Txt Box:
Name: Bank, Not visible
CS: [Bank] Not visible

Detail Section:
Text Box:
Name: Descriptions, Not visible
CS: [Description], Not visible and

Text Box:
Name: CkAmt, Not visible
CS: [CkAmt], Not visible

Description Footer:
Text Box:
Name: Descriptions,
CS: [Description],

Text Box:
Name: TotalCkAmt
CS: =Sum([CkAmt])

Whose Footer
Text Box:
Name: WhoesExpenseIsIt
CS: [="Total " & [Whoes] & " :"]

Text Box:
Name: ATotExpSum
CS: [=Sum([CkAmt])]


Report Footer
Text Box:
Label: Total Arvest Expenses
Name: TxtExpenseSum
CS: [=Sum([CkAmt])]

After the SubRpt_AExpenses_Yearly, I have tried leaving the Total Arvest
expenses out of the SubRpt_AExpenses_Yearly and putting the Text Box in the
Detail Section of the main report Rpt_FinancialStatement_Yearly, but I get an
error message each time.

Therefore, I have tried a combination of formulas in the Report Footer of
the Rpt_FinancialStatement_Yearly, I have yet to obtain anything except a
#Error message.

Currently,I have

Text Box:
Label: ArvestEndBalance
Name: AnEndingBalance
CS: =[TxtRunAssets]-[TxtRunExp]

Again, I tried to be as brief as possible. I hope I have recorded the things
you need and the information you have will be enough to answer my questions.
I still must do this for another bank in the same report.

May God truly bless you for your patience.

Karen


:

Please provide your background information in a reply. I don't recall your
report setup and what "wording and position" have to do with anything.

--
Duane Hookom
Microsoft Access MVP


:

Duane,

Finally getting back. I think I have that. However, when I use the "Between
[Forms]![FrmDATES]![TxtStart] And [Forms]![FrmDATES]![TxtEnd] I get about 27
pages of a report and the beginning balance, income, and expenses of each
month are included.

How can I just get the report to pull the beginning balance of the date I
give it, for example, 9/1/07.

FYI I have started writing the information of each subreport--the query,
text boxes, etc. but that is a lot of information and do not want to post it
unless absolutely necessary.

Thank you so much for you patience and help.

Karen

:

I doubt "[form]![BBDate]![txtStat]" will work since it should probably by
"[form]![BBDate]![txtStart]". Also in all cases, you should be using [Forms]
not [form]. Please copy and paste your expressions so the syntax matches your
actual and I can see the upper and lower case letters.

Here's what I know about retrieving values from a subreport into a main
report:

- A subreport is a control on your main report
- The subreport control has "Name" and "Source Object" properties
These are often the same value but might be different. When
they are different, you need to use the "Name" property, not the
"Source Object".
* assume the subreport control name is "srptOne"
- The typical setup has a text box in the report footer of the subreport
containing an aggregated value.
* assume this text box is "txtSumQty"
- You can add a text box on the main report in the same section as the
subreport with an expression like:
* assume this text box is "txtSumFromsrptOne"
=srptOne.Report.txtSumQty
- If your subreport might not return any records, you need to use
=IIf(srptOne.Report.HasData, srptOne.Report.txtSumQt, 0)
- If you want the value from the subreport to be displayed in a section
of the main report other than section containing the subreport:
- create txtSumFromsrptOne as above and
- add a text box in the other section with a control source of:
=txtSumFromsrptOne