D-SQL (9/12/2012)
Yes this is the same query they just wanted instead of actual date range tblProcessingFile.Funded to (dbo.tblLoan.Expected_Close = 9) because some actual close on the 1st through the 5th.Is there a way to use (dbo.tblLoan.Expected_Close = 9) and have the month change every month in the automated report? This month the report will run on the last day and have 9 then the next month at the end of the have 10 and so on.
Thanks for your help
This really isn't explaining or answering the question. I asked you where does this value come from. Is this the month during which the report is running or is it the month folling, what? I also asked about the hardcoded year. I am sure that you will want that automated as well so that you don't have to modify the code later when it needs to change to 2013.
If, as you say, this is same code why did you poost old code instead of the new code I provided? Just asking.