Search results

Okay this obviously does not work. I am working on the code right now. Will post it in a few minutes.

Didn't mean to hit enter. Let's try this again. (This is my first time attempting to use recordset). Private Sub Command45_Click() On Error GoTo Err_Command45_Click Dim rsReser As DAO.RecordSet Set rsReser = MyDBName.OpenRecordSet ("tblReportDates","ReportDay") For ReportDay Between...

Alright, I have the Reports form that has [frmReports]![StartDate] and [frmReports]![EndDate]. I want my table, tblReportDates, to autopopulate all days between these two dates. So after I hit the generate Report button, before the report is generated, I would like to have the table updated...

Thanks again. I was just using google. Next time I will search through this site first.

Hey I am having a hard time finding any information on how to fill the date table mentioned earlier. Any suggestions as to how I would fill it? I looked for recordset but I did not find anything.

I have been doing some research and it appears that what I need to do is to create a loop, but I do not know how to do this. Help?

Have you considered making a query? In the criteria for your date field, put "2009/2010" Or you could put a Textbox in the form and change the query criteria to = [FormName]![Textbox] Then create a report off of your new query.

Hey all, I have a report that reports issues per month. In this report the issues are separated into issues per day - that is open issues, opened issues, closed issues, and overdue issues for each particular day. This is all put in the graph. This is fine. The graph reports every 7 days and...

Hey all, I have a report that reports issues per month. In this report the issues are separated into issues per day - that is open issues, opened issues, closed issues, and overdue issues for each particular day. This is all put in the graph. This is fine. The graph reports every 7 days and...

The date suggestion worked well. Now onto other parts of the database. Thanks a lot Paul!

Alright I got all of this to work, but now on my graph there are way too many dots haha - is there a way to only take every 3rd or 4th? I see that you can change the Axis, but how do you change the data? I am guessing that this will have to be done back in the query.

Okay I just got it. In the query I just make an IIF statement for each. Like this: Expr1: IIf([Closed] Is Null,"0",[Closed])

Thank you again. Also - I am running into a problem as I graph: for Opened, Closed, and Overdue, there are days that have one or more of these not occurring and thus the day shows up blank in the query I use to make the graph. Is there any way I can make null values show up as zero?

Alright I just tried that but it gave me far more Open issues than I actually had open on each date. I played with it for a bit and this worked out: SELECT [Index], [DateReceived], [Closed], tblReportDate.ReportDay FROM tblReportDate INNER JOIN tblIssues ON...

Should I alter the closed part of the Base Statement? I feel like that is where my error is.

Hey that worked out really well - all dates are now listed. Quick question though - on the Open Issues by Date, the end of the month only shows 1 issue open when I know that there were more issues opened on that date - they just haven't been closed yet. Here is the query for Open Issues: Base...

The only problem is that the fields only show when all of the dates have entries...

Okay I think I know what you mean. I think I got it: SELECT tblReportDate.ReportDay, qryAgeClosed.Closed, qryAgeOpen.Open, qryAgeOpened.Opened, qryAgeOverdue.Overdue FROM (((tblReportDate INNER JOIN qryAgeOverdue ON tblReportDate.ReportDay = qryAgeOverdue.ReportDay) INNER JOIN qryAgeOpened ON...

Okay I tried this, but I still get repeats: SELECT tblReportDate.ReportDay, qryAgingGraphTotalBase.Closed, qryAgingGraphTotalBase.Open, qryAgingGraphTotalBase.Opened, qryAgingGraphTotalBase.Overdue FROM qryAgingGraphTotalBase LEFT JOIN tblReportDate ON qryAgingGraphTotalBase.ReportDay =...

So I made the query in post #36 from the separate 4 queries and the ReportDate table. This was going to be my base like I had with the other 4 individual queries, but maybe I don't need that? Can I just make this the main query that puts all of them together?