Hi , thanks in advance to all
I have this dlookup that is suppose to get a date(NewValue) from a table(Audittrail) where FormName = frmactiondetails(this is a column in audittrail) and where actionID(which is on the form frmactiondetails) is a date.
=DLookUp("NewValue","[tblAuditTrail]","[FormName]='frmActionDetails' And ActionID=" & [Reports]![PATS_ACTIONID])
Any reason why I am getting an error?
I have this dlookup that is suppose to get a date(NewValue) from a table(Audittrail) where FormName = frmactiondetails(this is a column in audittrail) and where actionID(which is on the form frmactiondetails) is a date.
=DLookUp("NewValue","[tblAuditTrail]","[FormName]='frmActionDetails' And ActionID=" & [Reports]![PATS_ACTIONID])
Any reason why I am getting an error?