hello
i want my database to tell me when the same person bought the same product 20 times
the product field is (Sanction_Code)
the type of this field is lookup so i can choose more than one product
the pid is the customers id
what to add to my code to get what i want
how to check
i want my database to tell me when the same person bought the same product 20 times
Code:
If DCount("*", "tbl_Personal_Sanctions_02", "[PID] = " & [PID]) = 0 Then
MsgBox ("congratulations")
Else
End If
the type of this field is lookup so i can choose more than one product
the pid is the customers id
what to add to my code to get what i want
how to check