Search results

*at the end of each week. (And then show multiple weeks). Or at the end of each month and then show multiple months.

That works out really well, thank you! Quick question - how would I be able to make this dynamic so that it shows all of the weeks in the month snapshot at the end of the week? Or if I could do this as a snapshot at the end of each month?

Thanks! That worked out.

I think I am not being as clear as I can be. So I will try to describe this a little more. And thank you so far - I appreciate it. Alright the final result is a dynamic report that changes based on the month. In this report I have a graph that changes each month. The part of the query that is...

Alright well say I call it 'Open,' do you know how I would be able to write the above expression?

Could I just do Expr4: Count(Closed) - Count(DatedReceived)

What would be ideal, is to have Expr4: Expr2 - Expr1. I'm not sure if you can do that though. Thank you so far for the help.

SELECT tblGPR.Index, tblGPR.DateReceivedinA, tblGPR.DateReceivedinB, Count(tblGPR.DateReceivedinB) AS Expr1, tblGPR.Closed, Count(tblGPR.Closed) AS Expr2, tblGPR.AssignedTo, tblGPR.IssueType, Abs(tblGPR!Closed>tblGPR!DueDate) AS Expr3, tblGPR.DueDate FROM tblGPR GROUP BY tblGPR.Index...

I tried this: Expr4: DCount("[Index]","tblGPR","[tblGPR]![DateReceived] = Between Forms![frmReports]![StartDate] And Forms![frmReports]![EndDate]”) - DCount("[Index]","tblGPR","[tblGPR]![Closed] = Between Forms![frmReports]![StartDate] And Forms![frmReports]![EndDate]") But it didn't work

Hey all, Is it possible to subtract dcount from dcount in a query? I am so far unable to do this. My code looked like this: Expr4: DCount("[Index]", "tblGPR", "[tblGPR]![ReceivedDate]") - DCount("[Index]", "tblGPR", "[tblGPR]![ClosedDate]") I would prefer to have something like this...

That is to say I am trying to count per day, how many Issues were open. I know it sounds easy, but for some reason I cannot put this into a query. I have been looking for the past few hours so any help you can give me would be much appreciated.

Hey all, I have a database that tracks specific issues. The issue comes into the office on a specific day (OpenDate) and is closed out on a specific day (ClosedDate). What I am trying to do is create a graph from a query that shows Opened issues by date, Closed issues by date, Overdue issues...