Question about wording and position overall total not correct

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?

"Duane Hookom" wrote:

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


"znibk" wrote:

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


"Duane Hookom" wrote:

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


"znibk" wrote:

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

"Duane Hookom" wrote:

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


"znibk" wrote:

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

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


"znibk" wrote:

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?

"Duane Hookom" wrote:

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


"znibk" wrote:

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


"Duane Hookom" wrote:

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


"znibk" wrote:

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

"Duane Hookom" wrote:

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


"znibk" wrote:

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

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

"Duane Hookom" wrote:

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


"znibk" wrote:

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?

"Duane Hookom" wrote:

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


"znibk" wrote:

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


"Duane Hookom" wrote:

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


"znibk" wrote:

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

"Duane Hookom" wrote:

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


"znibk" wrote:

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?

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


"znibk" wrote:

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

"Duane Hookom" wrote:

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


"znibk" wrote:

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?

"Duane Hookom" wrote:

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


"znibk" wrote:

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


"Duane Hookom" wrote:

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


"znibk" wrote:

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

"Duane Hookom" wrote:

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