ConfusedNAccess
Technical User
The following query is not returning the correct due date. I have reports (sheetrowtext) that are are Decemeber reports that should show a due date of 2007, however they are coming back for this year. There is a field that i'm not using, called "actual year" which shows the year of the report.
meaning if the report is active from year 2005, 2006 2007 ,etc... How can I use this field to reflect the correct due date.
due dates can range from those years as well, I guess that's why it's pulling it out.
IIf([dbo_ActualReports].[Active12]=-1 And [dbo_ActualReports].[Month12Value]=0 And Year([dbo_ActualReports].[Month12DueDate])=Year(Now()) And IsNull([dbo_ActualReports].[Month12SignOff]) And [dbo_ActualReports].[Month12DueDate]<=[Enter paramater for date to check],([dbo_BorrowerReports].[SheetRowText] & " " & [dbo_ActualReports].[Month12DueDate]),[dbo_ActualReports].[Month12SignOff]) AS [Dec]
meaning if the report is active from year 2005, 2006 2007 ,etc... How can I use this field to reflect the correct due date.
due dates can range from those years as well, I guess that's why it's pulling it out.
IIf([dbo_ActualReports].[Active12]=-1 And [dbo_ActualReports].[Month12Value]=0 And Year([dbo_ActualReports].[Month12DueDate])=Year(Now()) And IsNull([dbo_ActualReports].[Month12SignOff]) And [dbo_ActualReports].[Month12DueDate]<=[Enter paramater for date to check],([dbo_BorrowerReports].[SheetRowText] & " " & [dbo_ActualReports].[Month12DueDate]),[dbo_ActualReports].[Month12SignOff]) AS [Dec]
