I have recently created an update query:

UPDATE Fixtures SET Total = ([Players Attitude]+[Clubs Official Attitude]+[Club Supporters Attitude]);

I basically want to know now, is there a way of getting this to automatically run when new data is added into the Fixtures table(Table that is being updated), because currently you have to run the query for it to work

Thanks

Hi,

Why do you want to store a calculate field?? You should get value on the fly using query/form/report.

You should not store this calculated value in your table ...

RDH