If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report/Sub-report Control Source
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 |
#2
|
|||
|
|||
Report/Sub-report Control Source
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 "znibk" wrote: 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 |
#3
|
|||
|
|||
Report/Sub-report Control Source
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 "Duane Hookom" wrote: 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 "znibk" wrote: 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 |
#4
|
|||
|
|||
Report/Sub-report Control Source
The fishing was great but the catching was lousy!
I'll check out the previous thread. -- Duane Hookom Microsoft Access MVP "znibk" wrote: 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 "Duane Hookom" wrote: 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 "znibk" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|