A
Antavas
I have two main tables in my database. Table One contains every record from a
report we work on monthly. Table Two has the exact same fields but it only
contains the records we find that have issues from Table One.
I have created parameter queries for both so that we can Enter the Location
and the Report period. Query 1 gives us the total # of records done over a
period and Query 2 gives us the issue records over a period.
Now what I am trying to do is this. I have to report the issue records
quarterly (handled by the date parameter in Query 2). I've built a report off
of Query 2 and it turned out just fine. My issue is that I also need to get
the total # of records for a location for the same time period on there.
So basically I'm trying to run my report. I choose the location, start date,
end date and it returns all issue records over that time period. But what I
also need is for it to return all of the records created for that location
for that period. I've tried to make Query 1 a subreport but it creates a loop
in the parameter fields.
What am I doing wrong or is this something that has to be 2 different reports?
report we work on monthly. Table Two has the exact same fields but it only
contains the records we find that have issues from Table One.
I have created parameter queries for both so that we can Enter the Location
and the Report period. Query 1 gives us the total # of records done over a
period and Query 2 gives us the issue records over a period.
Now what I am trying to do is this. I have to report the issue records
quarterly (handled by the date parameter in Query 2). I've built a report off
of Query 2 and it turned out just fine. My issue is that I also need to get
the total # of records for a location for the same time period on there.
So basically I'm trying to run my report. I choose the location, start date,
end date and it returns all issue records over that time period. But what I
also need is for it to return all of the records created for that location
for that period. I've tried to make Query 1 a subreport but it creates a loop
in the parameter fields.
What am I doing wrong or is this something that has to be 2 different reports?