Report/Sub-report Control Source

[znibk]

Hope some one can help me. I am using Access 2003 and am in the process of
creating a financial report. So far, I have the Main Report containing the
date (Month Year)--I am using that as the parameter because I can get the
total of each specific field in a sumquery. If I use the parameter [Between
[Enter Start Date] And [Enter End Date], I achieve daily totals for the
specific field, and that is not what I need; the Beginning Balance and,
hopefully the Ending Balance in the Report Footer (getting error message, the
expression I'm using is at the bottom of the page.

Okay--in the Main Report, I have created a Bank Header. In it, I have the
Beginning Balance and Reference Date.

In the Detail Section, I have both the first and second sub-reports.
In the first sub_report, I have the income, subrpt_income, in the second
subreport, I have the expenses, subrpt_expenses.

In the Report Footer, I want the Ending Balance.

When I run the report, everything lines up beautifully. However, getting the
final result is a bit long.

Each of the three (report; sub-reports) are pulled from a different sumquery
which shows the totals for each field of income or expenses. The parameter
criteria for each query (report--sub-report) is [Enter Reference Date as "mmm
yyyy"]

When I run the report, it asks me for the first reference date, then it asks
me to "Enter Parameter Value subreport_Income, then the Parameter Value of
subreport_expense, then it asks an additional two times for the reference
date.

I thought since I made the query parameter exactly the same, the report
would ask me for that information only one time.

I read through several of the other question/answers about sub-reports, etc.
I tried creating an unbound form with the reference date on it. I put the row
source to the tblMONTHYEAR. I click the correct Month Year, leave the form
open, open the report and when I open it, it continues to do as described
above.

Can someone please tell me what I did wrong, and then tell me in exact
details what I should be doing. Please make ithe instructions clear and
simple as if you were writing instructions for a textbook.

FYI, the expression I used to try to obtain the Ending Balance is
"=(sum([ABegBal])+sum([ATotInc])-sum([ATot Exp]) I keep getting an error
message.

I really hope there is someone out there who can help me out. I will be
forever grateful. k

 

[Duane Hookom]

This question sounds too familiar. However to get a total from a subreport
(assuming a report total text box named txtExpTotal) you would add a text box
in the same section of the main report with a control source of:
=subrptExpName.Report.txtExpTotal
IMHO don't ever use parameter prompts unless you like your interface to:
-not remember
-not provide a default
-not check for validity
-not display more than one value at a time
-keep asking and asking and asking and asking for the criteria value.

--
Duane Hookom
Microsoft Access MVP

Hope some one can help me. I am using Access 2003 and am in the process of
creating a financial report. So far, I have the Main Report containing the
date (Month Year)--I am using that as the parameter because I can get the
total of each specific field in a sumquery. If I use the parameter [Between
[Enter Start Date] And [Enter End Date], I achieve daily totals for the
specific field, and that is not what I need; the Beginning Balance and,
hopefully the Ending Balance in the Report Footer (getting error message, the
expression I'm using is at the bottom of the page.

Okay--in the Main Report, I have created a Bank Header. In it, I have the
Beginning Balance and Reference Date.

In the Detail Section, I have both the first and second sub-reports.
In the first sub_report, I have the income, subrpt_income, in the second
subreport, I have the expenses, subrpt_expenses.

In the Report Footer, I want the Ending Balance.

When I run the report, everything lines up beautifully. However, getting the
final result is a bit long.

Each of the three (report; sub-reports) are pulled from a different sumquery
which shows the totals for each field of income or expenses. The parameter
criteria for each query (report--sub-report) is [Enter Reference Date as "mmm
yyyy"]

When I run the report, it asks me for the first reference date, then it asks
me to "Enter Parameter Value subreport_Income, then the Parameter Value of
subreport_expense, then it asks an additional two times for the reference
date.

I thought since I made the query parameter exactly the same, the report
would ask me for that information only one time.

I read through several of the other question/answers about sub-reports, etc.
I tried creating an unbound form with the reference date on it. I put the row
source to the tblMONTHYEAR. I click the correct Month Year, leave the form
open, open the report and when I open it, it continues to do as described
above.

Can someone please tell me what I did wrong, and then tell me in exact
details what I should be doing. Please make ithe instructions clear and
simple as if you were writing instructions for a textbook.

FYI, the expression I used to try to obtain the Ending Balance is
"=(sum([ABegBal])+sum([ATotInc])-sum([ATot Exp]) I keep getting an error
message.

I really hope there is someone out there who can help me out. I will be
forever grateful. k

 

[znibk]

Yes Duane it's me. Did you enjoy your fishing trip and catch any fish? Wasn't
sure when you would be back so I decided to ask the group out there if anyone
could help. Since you are back, would you give me a minute and I will tell
you on the "Still have hope . . . " post what I've done. k

This question sounds too familiar. However to get a total from a subreport
(assuming a report total text box named txtExpTotal) you would add a text box
in the same section of the main report with a control source of:
=subrptExpName.Report.txtExpTotal
IMHO don't ever use parameter prompts unless you like your interface to:
-not remember
-not provide a default
-not check for validity
-not display more than one value at a time
-keep asking and asking and asking and asking for the criteria value.

--
Duane Hookom
Microsoft Access MVP

Hope some one can help me. I am using Access 2003 and am in the process of
creating a financial report. So far, I have the Main Report containing the
date (Month Year)--I am using that as the parameter because I can get the
total of each specific field in a sumquery. If I use the parameter [Between
[Enter Start Date] And [Enter End Date], I achieve daily totals for the
specific field, and that is not what I need; the Beginning Balance and,
hopefully the Ending Balance in the Report Footer (getting error message, the
expression I'm using is at the bottom of the page.

Okay--in the Main Report, I have created a Bank Header. In it, I have the
Beginning Balance and Reference Date.

In the Detail Section, I have both the first and second sub-reports.
In the first sub_report, I have the income, subrpt_income, in the second
subreport, I have the expenses, subrpt_expenses.

In the Report Footer, I want the Ending Balance.

When I run the report, everything lines up beautifully. However, getting the
final result is a bit long.

Each of the three (report; sub-reports) are pulled from a different sumquery
which shows the totals for each field of income or expenses. The parameter
criteria for each query (report--sub-report) is [Enter Reference Date as "mmm
yyyy"]

When I run the report, it asks me for the first reference date, then it asks
me to "Enter Parameter Value subreport_Income, then the Parameter Value of
subreport_expense, then it asks an additional two times for the reference
date.

I thought since I made the query parameter exactly the same, the report
would ask me for that information only one time.

I read through several of the other question/answers about sub-reports, etc.
I tried creating an unbound form with the reference date on it. I put the row
source to the tblMONTHYEAR. I click the correct Month Year, leave the form
open, open the report and when I open it, it continues to do as described
above.

Can someone please tell me what I did wrong, and then tell me in exact
details what I should be doing. Please make ithe instructions clear and
simple as if you were writing instructions for a textbook.

FYI, the expression I used to try to obtain the Ending Balance is
"=(sum([ABegBal])+sum([ATotInc])-sum([ATot Exp]) I keep getting an error
message.

I really hope there is someone out there who can help me out. I will be
forever grateful. k

 

[Duane Hookom]

The fishing was great but the catching was lousy!

I'll check out the previous thread.

--
Duane Hookom
Microsoft Access MVP

Yes Duane it's me. Did you enjoy your fishing trip and catch any fish? Wasn't
sure when you would be back so I decided to ask the group out there if anyone
could help. Since you are back, would you give me a minute and I will tell
you on the "Still have hope . . . " post what I've done. k

This question sounds too familiar. However to get a total from a subreport
(assuming a report total text box named txtExpTotal) you would add a text box
in the same section of the main report with a control source of:
=subrptExpName.Report.txtExpTotal
IMHO don't ever use parameter prompts unless you like your interface to:
-not remember
-not provide a default
-not check for validity
-not display more than one value at a time
-keep asking and asking and asking and asking for the criteria value.

--
Duane Hookom
Microsoft Access MVP

Hope some one can help me. I am using Access 2003 and am in the process of
creating a financial report. So far, I have the Main Report containing the
date (Month Year)--I am using that as the parameter because I can get the
total of each specific field in a sumquery. If I use the parameter [Between
[Enter Start Date] And [Enter End Date], I achieve daily totals for the
specific field, and that is not what I need; the Beginning Balance and,
hopefully the Ending Balance in the Report Footer (getting error message, the
expression I'm using is at the bottom of the page.

Okay--in the Main Report, I have created a Bank Header. In it, I have the
Beginning Balance and Reference Date.

In the Detail Section, I have both the first and second sub-reports.
In the first sub_report, I have the income, subrpt_income, in the second
subreport, I have the expenses, subrpt_expenses.

In the Report Footer, I want the Ending Balance.

When I run the report, everything lines up beautifully. However, getting the
final result is a bit long.

Each of the three (report; sub-reports) are pulled from a different sumquery
which shows the totals for each field of income or expenses. The parameter
criteria for each query (report--sub-report) is [Enter Reference Date as "mmm
yyyy"]

When I run the report, it asks me for the first reference date, then it asks
me to "Enter Parameter Value subreport_Income, then the Parameter Value of
subreport_expense, then it asks an additional two times for the reference
date.

I thought since I made the query parameter exactly the same, the report
would ask me for that information only one time.

I read through several of the other question/answers about sub-reports, etc.
I tried creating an unbound form with the reference date on it. I put the row
source to the tblMONTHYEAR. I click the correct Month Year, leave the form
open, open the report and when I open it, it continues to do as described
above.

Can someone please tell me what I did wrong, and then tell me in exact
details what I should be doing. Please make ithe instructions clear and
simple as if you were writing instructions for a textbook.

FYI, the expression I used to try to obtain the Ending Balance is
"=(sum([ABegBal])+sum([ATotInc])-sum([ATot Exp]) I keep getting an error
message.

I really hope there is someone out there who can help me out. I will be
forever grateful. k