Hey
Having an issue with this , any help appreciated!
[tblMaint_Rqst_Request] = table of maintenance requests
[MT_Rqst_Location] = field in table containing location (can be numerical or text)
[MT_Status_Value] = field in table containing status of job as number, ie 1= open, 2 = in progress...