Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
UPDATE tblAccounts
SET DateClosed = DMax("DateTransactn","Transactn","AccountID=" & [AccountID])
UPDATE tblAccounts
SET DateClosed = DMax("DateTransactn","Transactn","AccountID=" & [AccountID] & " AND Status='C' AND CustomerID='1' and ProductID='LD'")
dhookom said:Second, you should provide the data types of significant fields.
error message said:"type conversion failure"
UPDATE tblAccounts
SET DateClosed = DMax("DateTransactn","Transactn","AccountID='" & [AccountID] & "' AND Status='C' AND CustomerID='1' and ProductID='LD'")