Search results

Here is the query that I used to make the above query: SELECT tblReportDate.ReportDay, qryAgeClosed.Closed, qryAgeOpen.Open, qryAgeOpened.Opened, qryAgeOverdue.Overdue FROM qryAgeClosed, qryAgeOpen, qryAgeOpened, qryAgeOverdue, tblReportDate GROUP BY tblReportDate.ReportDay...

Okay I modified it, but still errors... SELECT tblReportDate.ReportDay, qryAgingGraphTotalBase.Closed, qryAgingGraphTotalBase.Open, qryAgingGraphTotalBase.Opened, qryAgingGraphTotalBase.Overdue, tblReportDate.ReportDay FROM qryAgingGraphTotalBase INNER JOIN tblReportDate ON...

Okay the queries are returning the respective counts, but I am still unsure as to how I would add all of these queries into one query. This is what I have, but there are errors: SELECT qryAgingGraphTotalBase.ReportDay, qryAgingGraphTotalBase.Closed, qryAgingGraphTotalBase.Open...

I took out count. So I am just not sure where to go from here: SELECT qryAgingGraphTotalBase.ReportDay, qryAgingGraphTotalBase.Closed, qryAgingGraphTotalBase.Open, qryAgingGraphTotalBase.Opened, qryAgingGraphTotalBase.Overdue FROM qryAgingGraphTotalBase GROUP BY...

Okay I tried that, but I went through and I tried to group by Avg, Sum, Count, but each column had its own value and it was the same all the way down. Here is what I have: SELECT tblReportDate.ReportDay, Count(qryAgeClosed.Closed) AS CountOfClosed, Count(qryAgeOpen.Open) AS CountOfOpen...

All of the queries have qryAgeClosedBase query like you had.

Before I get that going I needed to finish this report that we spoke of before- the one where we show the currently opened, closed, open, and overdue on each date. I have done separate queries that count each area like you did before. Now I want to put all of these in one query. The only...

And then what are your thoughts on how to make a recordset? I am going to try to get one going right now - I just read up a little on recordset. I will post the code if I run into a problem. Thanks again.

haha wow I can't believe I didn't see that. wow haha

Also - I am doing this query, but it does not work: (Says there is a missing operator): SELECT [Index], [DateReceived], [Closed], [tblReportDate].[ReportDay] FROM tblReportDate INNER JOIN tblIssues ON ([tblReportDate].[ReportDay]<=[tblIssues].[Closed]) AND...

Thanks again for your help!

The form that you saw in the database that I sent you has dates you must put in manually, but in the database I have, the StartDate and EndDate auto-populate.

Alright well the way that I have my reports page set up, the dates are automatically filled in to reflect the current month. Is there any other way to have the recordset and loop? And how do you set up a recordset and loop? Thanks, I have never used recordset.

This is great - but quick question - is there any way that I can make this dynamic so that I don't have to go back and change the ReportDate table each month?

That is exactly what I'm looking for. How'd you do that? And then would I be able to copy that to also show how many issues were closed, opened, and overdue on each day? Thanks!

Just make sure that you insert the dates into the form field before opening the query. Just put in 06/01/2009 to 06/30/2009. Thanks!

Here is a quick example of what I am trying to do. I had to make a new db to show you. What I would like to do is show how many issues are overdue on each day, how many issues were opened on each day, how many issues were closed on each day, and how many issues were open at the end of the day...

Alright, I am still not sure exactly how I would do this. When I try to do this, I am told that I need to adjust the relationships.

The hard part I've found is that each record has its own start and end date. On top of that, there is a Query Start and End date (for a report) that needs to go through and count how many records are currently open each day.

I guess what I am saying is how would I be able to make this continously sum open issues and then subtract the issue from that sum once its closed date has passed. So let's say 3 issues were opened as follows: Issue DateOpened DateClosed A 6/5/09 6/12/09 B 6/9/09...