473,396 Members | 2,009 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Passing multiple parameter dates to subreports for computation to main report

2
Hi all,

I'm a novice to Access and programming in general so please bare with me.

I have several queries from different databases in a linked table database, each of which has its own report. The purpose is for the user to set a date parameter and find out which products have failed production and which have passed. Thus, each has a date parameter and a footer calculation that sums up total and failed. The queries are all unrelated to each other.

Now, I need to combine all of those reports together. I have an unbounded main report that is housing all of the subreports for them to be ultimately summed up individually and put back into 2 text boxes in the main report.

The problem is when main report is run, the user has to type in start and end dates about 10 times which is very annoying.

I would like to make it so entering in one date automatically filters each individual report and does the calculations behind the scenes.

Does anyone know what the best way to go about this would be? I'm not even sure where to start.
Jul 17 '13 #1
2 1342
eipts
2
Some more information:

The tables are pulled form 10 different databases so there is no single database for the query. Each table is is completely unrelated to the other table. Each query is based on its corresponding table and each report on its corresponding query. The purpose of the linked table is that the data will be changing in the future from the different databases.
Jul 17 '13 #2
Rabbit
12,516 Expert Mod 8TB
Use a form to input the dates with a button to open the report. Change the queries to use the date inputted on the form.
Jul 17 '13 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Henrootje | last post by:
I have a report concerning a customer. In this report we find four subreports. They are in layout identical but data comes from different tabel. Now on the main report I count the totals of each...
2
by: AccessAl | last post by:
:confused: I have inheritted a system with reports that were probably written by a novice access programmer. My problem is a report with a dozen subreports in them. I had to add another subreport...
1
by: josecruz | last post by:
I have created a main report, which is controlled with a date range parameter from the main form. The report has several sub reports, which perform calculations (counts and averages at the subreport...
2
by: somanyusernamesaretakenal | last post by:
Access 2003. I have generated multiple crosstabs from the same main table. (I have multiple value fields) Then each of these crosstabs is created into a report. I am trying to combine all these...
3
by: DeanL | last post by:
Hi all, I'm currently pulling out my already thin hair and need a little help if possible. I have an Access 97 db that is used to store inspection information for different regions. My report...
2
by: kabradley | last post by:
Hello everyone. I have three reports that I would like to put into one main report. I tried creating the main report and then putting three seperate subreports in the detail section of the parent...
1
by: Faith0999 | last post by:
I am currently a novice to using MS-Access. I currently have a report that I created from the following query. SELECT item.id, item.type, item.location, item.shipdate FROM Item WHERE item.type...
6
by: Brett Barry: Go Get Geek! | last post by:
Hello, I have a main report with a Record Source, a DateToday table, that has the current Month and Year. I have about 60 queries, each pulling different data via ODBC, that I am creating...
0
by: jimatqsi | last post by:
I once told a client how easy it is to make reports in Access. Since then, he's developed a savant-like ability to ask for reports that I find nearly impossible to do quickly and easily. Here is yet...
2
by: DanicaDear | last post by:
I have been trying to do for two hours now what I *thought* would be a simple task. Can someone point me in a better direction? I have a report that shows which customers are due up for an order....
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.