One Report, Multiple dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top