hello guys,
i have a query that counts how many times the same record exist
and i have table that i want to update the field on counter with the data from this query
this is the query
now i want to update the field code1counter in table 1 with the data from the field txt_Numbers_Original in the query
any solution plz
i have a query that counts how many times the same record exist
and i have table that i want to update the field on counter with the data from this query
this is the query
Code:
SELECT Count(tbl_Personal_Sanctions_02.Sanction_Date) AS txt_Numbers_Original
FROM tbl_Personal_Sanctions_02
WHERE (((tbl_Personal_Sanctions_02.PID)=[Forms]![frm_Sanctions_Out]![PID]) AND ((tbl_Personal_Sanctions_02.Sanction_Date) Between [Forms]![frm_Sanctions_Out]![Sanctions_Date]-3650 And [Forms]![frm_Sanctions_Out]![Sanctions_Date]) AND ((tbl_Personal_Sanctions_02.Sanction_Code.Value)=[Forms]![frm_Sanctions_Out]![Sanctions_Code_01]));
now i want to update the field code1counter in table 1 with the data from the field txt_Numbers_Original in the query
any solution plz