How can i calculate or replace a field in a table.

There are 2 tables

Events and members

Fields in events are
name
date
location
present

The table members contains a field with eventdate.

I want field present in table events to contain the number of members where
eventdate = date.

A replace query wont work for some reason. I have tried de DCount with
options but without result