One Report, Multiple dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sam - 22 Jan 2006 11:11 GMT

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

Reply to this Message

Ofer - 22 Jan 2006 11:19 GMT

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

Signature

\\// Live Long and Prosper \\//
BS"D

> Hello All
>
[quoted text clipped - 12 lines]
>
> Thanks

Reply to this Message

Sam - 22 Jan 2006 11:28 GMT

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?

> If each query return the right data, and you want to combine all queries
> together for one report then:
[quoted text clipped - 32 lines]
> >
> > Thanks

Reply to this Message

Ofer - 22 Jan 2006 12:27 GMT

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]

Signature

\\// Live Long and Prosper \\//
BS"D

> Thanks for the very quick response Ofer
>
[quoted text clipped - 41 lines]
> > >
> > > Thanks

Reply to this Message