05-20-2022 01:34 AM
Case
When IsDate(tblAssets.LastLsAgent) = 1 And IsDate(tblAssets.LastActiveScan)
= 0 Then tblAssets.LastLsAgent
When IsDate(tblAssets.LastActiveScan) = 1 And IsDate(tblAssets.LastLsAgent)
= 0 Then tblAssets.LastActiveScan
When tblAssets.LastLsAgent > tblAssets.LastActiveScan Then
tblAssets.LastLsAgent
When tblAssets.LastActiveScan > tblAssets.LastLsAgent Then
tblAssets.LastActiveScan
Else ''
End As [Last Scan Date]
05-31-2022 08:01 PM