gistfile1.sql

SELECT problems.id, problems.title, problems.start_date, 
problems.uid, problems.uemail, tblUsers.uid, customers.custname
FROM (
      customers INNER JOIN 
        (
         problems INNER JOIN status ON 
         problems.status = status.status_id
        ) ON 
      customers.customer_id = problems.customer
     ) 
INNER JOIN tblUsers ON 
problems.rep = tblUsers.sid

gistfile2.bas

Dim listStr, whereStr
 
listStr = "SELECT problems.id, problems.title, problems.start_date, " & _
  "problems.uid, problems.uemail, tblUsers.uid, customers.custname "
  "FROM (customers INNER JOIN " & _
  "(problems INNER JOIN status ON problems.status = status.status_id) ON " & _
  "customers.customer_id = problems.customer) " & _
  "INNER JOIN tblUsers ON problems.rep = tblUsers.sid " & _
  "WHERE " & whereStr