I have two main tables in my database. Table One contains every record from
a
re****t 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 Re****t 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 re****t the issue records
quarterly (handled by the date parameter in Query 2). I've built a re****t
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 re****t. 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 subre****t but it creates a
loop
in the parameter fields.
What am I doing wrong or is this something that has to be 2 different
re****ts?
