CCTMedic
04-22-2009, 05:50 PM
I am new to access so please be kind. I have created a database on Access 2007 that is filled using a User Interface form. The UI is linked to lookup fields as well as being the input source to the database for date fields. The lookup data is spread among tables that contain the various datapoints. I have a query of the main database set up to limit and filter the data for the report. I used the "Between [start date] and [end date]" to filter all of the data based on the date. The filter criteria is not set in the subreport queries it is only set in the query of the main database under "Criteria".
To my surprise it all works pretty well. The first report I made is a report that was created through the wizard and it works very well. Same filter as above. The difference is that I cannot get to the data I need, formatted in the way that is required for the second report using the wizard. That is, each topic of the subreport with totals and percentages for each topic. Therefore, I created the second report using the "design report" function.
Both reports do what I want them to do. The notable difference between the first and the second report is that If I open the first report I fill in the date parameters and off it goes to do exactly what I want. I do not have to re-enter any dates unless I close the report and then reopen it. With the second report I need to fill in the date parameters 10 times before the report will open. Once open if I wish to save the report or print it etc I have to re enter the date parameters for each operation 10 times.
Linking a field has been unproductive or impossible apparently due to the report being unbound. If I attempt to make the report bound to the query or the database when I create it, such that I can use master and child field links, major problems appear on the report; it becomes 255 pages long with data spread all over the place. The original report is 2 pages long.
I have tried filtering by using SQL on a form as suggested elswehere on the internet but it did not work; may have been a problem on my end though I followed the direction to the letter.
Please help if you can. Please be as specific as you can with the instructions. I am self taught through much trial, error and research on the internet. All of this to fulfill my employers expectations even though I am not an Information Tec person or a programmer. Oh, well, the boss is the boss. Thus, I am both pressured to get the work done yet am relatively unprepared. I hope you can help me continue on my quest to learn more about Access. Keeping my job would be nice too!
Thank you in advance for your time.
To my surprise it all works pretty well. The first report I made is a report that was created through the wizard and it works very well. Same filter as above. The difference is that I cannot get to the data I need, formatted in the way that is required for the second report using the wizard. That is, each topic of the subreport with totals and percentages for each topic. Therefore, I created the second report using the "design report" function.
Both reports do what I want them to do. The notable difference between the first and the second report is that If I open the first report I fill in the date parameters and off it goes to do exactly what I want. I do not have to re-enter any dates unless I close the report and then reopen it. With the second report I need to fill in the date parameters 10 times before the report will open. Once open if I wish to save the report or print it etc I have to re enter the date parameters for each operation 10 times.
Linking a field has been unproductive or impossible apparently due to the report being unbound. If I attempt to make the report bound to the query or the database when I create it, such that I can use master and child field links, major problems appear on the report; it becomes 255 pages long with data spread all over the place. The original report is 2 pages long.
I have tried filtering by using SQL on a form as suggested elswehere on the internet but it did not work; may have been a problem on my end though I followed the direction to the letter.
Please help if you can. Please be as specific as you can with the instructions. I am self taught through much trial, error and research on the internet. All of this to fulfill my employers expectations even though I am not an Information Tec person or a programmer. Oh, well, the boss is the boss. Thus, I am both pressured to get the work done yet am relatively unprepared. I hope you can help me continue on my quest to learn more about Access. Keeping my job would be nice too!
Thank you in advance for your time.