UPPDATE fileds with count

[sal21]

table MOVIM_CB
DATA1 CB AN
25/05/2014 AAAA
27/06/2014 BBBB
...
table ANOM_CB
DATA1 CB
25/05/2014 AAAA
27/06/2014 BBBB
25/05/2014 AAAA
25/05/2014 BBBB

I need a sql to update field AN of table MOVIM_CB with the count CB of table ANOM_CB based the date=25/05/2014

final result:
table MOVIM_CB
DATA1 CB AN
25/05/2014 AAAA 2
27/06/2014 BBBB

[HansV]

For example:

UPDATE MOVIM_CB INNER JOIN ANOM_CB ON (MOVIM_CB.CB = ANOM_CB.CB) AND (MOVIM_CB.DATA1 = ANOM_CB.DATA1) SET MOVIM_CB.AN = DCount("*","ANOM_CB","DATA1=#2014-05-25# AND CB='" & [MOVIM_CB].[CB] & "'")
WHERE (((ANOM_CB.DATA1)=#5/25/2014#));

[sal21]

For example:

UPDATE MOVIM_CB INNER JOIN ANOM_CB ON (MOVIM_CB.CB = ANOM_CB.CB) AND (MOVIM_CB.DATA1 = ANOM_CB.DATA1) SET MOVIM_CB.AN = DCount("*","ANOM_CB","DATA1=#2014-05-25# AND CB='" & [MOVIM_CB].[CB] & "'")
WHERE (((ANOM_CB.DATA1)=#5/25/2014#));

sorry me but i can't test now...