sqlQuery = "SELECT Count(*) AS CountOfTYPE " & _ "FROM (USERS INNER JOIN HISTORY ON USERS.ID HISTORY.USER_ID) INNER JOIN TYPE ON HISTORY.COUPONTYPE_ID TYPE.ID " & _ "WHERE (((TYPE.TYPE)='1 client') AND CONCAT (USERS.T_FirstName," ",USERS.T_LastName) = '" & userLoggedName & "' AND ((Format([history].[modifydatetime],'DD/MM/YYYY'))=#" & [Forms]![coupon_Activities_form]![txtDateRef] & "#))"
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionsqlQuery = "SELECT Count(*) AS CountOfTYPE " & _ "FROM USERS " & _ " INNER JOIN HISTORY ON USERS.ID = HISTORY.USER_ID " & _ " INNER JOIN TYPE ON HISTORY.COUPONTYPE_ID = TYPE.ID " & _ "WHERE ( " & _ " TYPE.TYPE='1 client' " & _ " AND " & _ " CONCAT(USERS.T_FirstName," ",USERS.T_LastName) = '" & userLoggedName & "' " & _ " AND " & _ " ( " & _ " Format([history].[modifydatetime],'DD/MM/YYYY')=#" & [Forms]![coupon_Activities_form]![txtDateRef] & "# " & _ " ) " & _ " ) " & _
CONCAT(USERS.T_FirstName,"",USERS.T_LastName) = '" & userLoggedName & "' " & _
"WHERE (((TYPE.TYPE)='1 client') AND CONCAT (USERS.T_FirstName,"",USERS.T_LastName) = '" & userLoggedName & "' AND ((Format([history].[modifydatetime],'DD/MM/YYYY'))=#" & [Forms]![coupon_Activities_form]![txtDateRef] & "#) "