I have the following RecordSource
and would like to Sort on calculated field intExpiryDay.
When I try to use
it is prompting me to enter a value for Parameter "dtmExpiry", which is used in intExpiryDay
Code:
SELECT dbo_tblManagementCommitteeInstance.intID, dbo_tblManagementCommitteeInstance.intManagementCommittee, dbo_tblManagementCommitteeInstance.dtmFrom,
dbo_tblManagementCommitteeInstance.dtmTo, dbo_tblManagementCommitteeInstance.bitD, dbo_tblManagementCommitteeInstance.dtmD, dbo_tblManagementCommitteeInstance.nvcLUC,
dbo_tblManagementCommitteeInstance.intD, dbo_tblIe.nvcName, dbo_tblIe.intMCTerm, dbo_tblIe.intMCTermAlert, DateAdd("m",[intMCTerm],[dtmFrom]) AS dtmExpiry,
DateAdd("m",-[intMCTermAlert],[dtmExpiry]) AS dtmExpiryAlert, DateDiff("d",Date(),[dtmExpiry]) AS intExpiryDay
FROM dbo_tblIe LEFT JOIN dbo_tblManagementCommitteeInstance ON dbo_tblIe.intID = dbo_tblManagementCommitteeInstance.intManagementCommittee
WHERE (((dbo_tblManagementCommitteeInstance.bitD)=False)) ;
and would like to Sort on calculated field intExpiryDay.
When I try to use
Code:
ORDER BY intExpiryDay
it is prompting me to enter a value for Parameter "dtmExpiry", which is used in intExpiryDay
Code:
DateDiff("d",Date(),[dtmExpiry]) AS intExpiryDay