Hello
I am using the below code, what SQL code would I need to use to show REFstatus to read "NOT ENOUGH DIGITS" or "TOO MANY DIGITS" along with the below
Many Thanks!
I am using the below code, what SQL code would I need to use to show REFstatus to read "NOT ENOUGH DIGITS" or "TOO MANY DIGITS" along with the below
Code:
SELECT TBLALLHRDetails.HRRefID,
TBLALLHRDetails.IDFKFullStaffDetailsID,
TBLALLHRDetails.HRReferenceNumber,
TBLALLHRDetails.OCCReferenceNumbers,
Switch(IsNull(TBLALLHRDetails.HRReferenceNumber + TBLALLHRDetails.OCCReferenceNumbers) Or
TBLALLHRDetails.HRReferenceNumber="N/A" Or
TBLALLHRDetails.OCCReferenceNumbers = "N/A", Null,
TBLALLHRDetails.HRReferenceNumber <> TBLALLHRDetails.OCCReferenceNumbers, "Do Not ",
True, "They ") + "Match" As RefStatus
FROM TBLALLHRDetails;
Many Thanks!