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
|
|||
|
|||
One Report, Multiple dates
Hello All
I need to generate a report that needs to call up data from different dates. For example, my data base records that date that a loan application is approved, declined, cancelled, settled ETC. I have set up my reports via queries. Each query has the following in the criteria line::- Between [Enter Start Date] And [Enter End Date] I have a query for each of the criteria as mentioned above (I.E. Date Loan settled, Date loan declined, Date Loan Cancelled) How can I merge these into one big fat report, noting that each of these dates for each category might happen on different dates Hope this makes sense!! Thanks |
#2
|
|||
|
|||
One Report, Multiple dates
If each query return the right data, and you want to combine all queries
together for one report then: 1. You can create 1 Report with three sub reports, one for each output 2. Create a query that combine all three queries, assuming that all queries structure is the same, using a union query Select * From Query1 Union Select * From Query2 Union Select * From Query3 3. If all criteria are on the same table, chane the select to include all criterias Select * From TableName Where DateFieldName1 Between [Enter Start Date] And [Enter End Date] Or DateFieldName2 Between [Enter Start Date] And [Enter End Date] ============================ For 1 and 2 base the report on the new recordsource I hope that what you are looking for -- \\// Live Long and Prosper \\// BS"D "Sam" wrote: Hello All I need to generate a report that needs to call up data from different dates. For example, my data base records that date that a loan application is approved, declined, cancelled, settled ETC. I have set up my reports via queries. Each query has the following in the criteria line::- Between [Enter Start Date] And [Enter End Date] I have a query for each of the criteria as mentioned above (I.E. Date Loan settled, Date loan declined, Date Loan Cancelled) How can I merge these into one big fat report, noting that each of these dates for each category might happen on different dates Hope this makes sense!! Thanks |
#3
|
|||
|
|||
One Report, Multiple dates
Thanks for the very quick response Ofer
I was looking at a union query, however each date that I want to report on is different and likewise for the data that is coolected from these dates. So that leaves option 2 out I do not understand options 1 & 3. Please note that I am very much a beginner when it comes to all of this.. Could you please expand on this? "Ofer" wrote: If each query return the right data, and you want to combine all queries together for one report then: 1. You can create 1 Report with three sub reports, one for each output 2. Create a query that combine all three queries, assuming that all queries structure is the same, using a union query Select * From Query1 Union Select * From Query2 Union Select * From Query3 3. If all criteria are on the same table, chane the select to include all criterias Select * From TableName Where DateFieldName1 Between [Enter Start Date] And [Enter End Date] Or DateFieldName2 Between [Enter Start Date] And [Enter End Date] ============================ For 1 and 2 base the report on the new recordsource I hope that what you are looking for -- \\// Live Long and Prosper \\// BS"D "Sam" wrote: Hello All I need to generate a report that needs to call up data from different dates. For example, my data base records that date that a loan application is approved, declined, cancelled, settled ETC. I have set up my reports via queries. Each query has the following in the criteria line::- Between [Enter Start Date] And [Enter End Date] I have a query for each of the criteria as mentioned above (I.E. Date Loan settled, Date loan declined, Date Loan Cancelled) How can I merge these into one big fat report, noting that each of these dates for each category might happen on different dates Hope this makes sense!! Thanks |
#4
|
|||
|
|||
One Report, Multiple dates
You can still use the union query, but you'll have to change the criteria
Query1 Where Field1 Between [Please enter start 1] And [Please enter end 1] Query2 Where Field2 Between [Please enter start 2] And [Please enter end 2] That way it will prompt you to enter different dates for each query ========================= It will be just as option 3 Select * From TableName Where DateFieldName1 Between [Enter Start Date1] And [Enter End Date1] Or DateFieldName2 Between [Enter Start Date2] And [Enter End Date2] -- \\// Live Long and Prosper \\// BS"D "Sam" wrote: Thanks for the very quick response Ofer I was looking at a union query, however each date that I want to report on is different and likewise for the data that is coolected from these dates. So that leaves option 2 out I do not understand options 1 & 3. Please note that I am very much a beginner when it comes to all of this.. Could you please expand on this? "Ofer" wrote: If each query return the right data, and you want to combine all queries together for one report then: 1. You can create 1 Report with three sub reports, one for each output 2. Create a query that combine all three queries, assuming that all queries structure is the same, using a union query Select * From Query1 Union Select * From Query2 Union Select * From Query3 3. If all criteria are on the same table, chane the select to include all criterias Select * From TableName Where DateFieldName1 Between [Enter Start Date] And [Enter End Date] Or DateFieldName2 Between [Enter Start Date] And [Enter End Date] ============================ For 1 and 2 base the report on the new recordsource I hope that what you are looking for -- \\// Live Long and Prosper \\// BS"D "Sam" wrote: Hello All I need to generate a report that needs to call up data from different dates. For example, my data base records that date that a loan application is approved, declined, cancelled, settled ETC. I have set up my reports via queries. Each query has the following in the criteria line::- Between [Enter Start Date] And [Enter End Date] I have a query for each of the criteria as mentioned above (I.E. Date Loan settled, Date loan declined, Date Loan Cancelled) How can I merge these into one big fat report, noting that each of these dates for each category might happen on different dates Hope this makes sense!! Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Parameter thru Form Dialog Box for REPORT | Sandy | Setting Up & Running Reports | 16 | January 10th, 2006 10:06 AM |
subreport not displaying in main report | JohnLute | Setting Up & Running Reports | 15 | November 17th, 2005 04:02 PM |
How to run a report for multiple selections? | Amit | Setting Up & Running Reports | 0 | February 9th, 2005 07:25 PM |
Help!! I'm running around in circles! | CathyA | New Users | 19 | December 12th, 2004 07:50 PM |
Start and End Dates not appearing in text box of report | ChuckW | Using Forms | 1 | June 17th, 2004 04:57 PM |