From your terse description, it sounds like you are trying to store a
calculated value. If so, don't (it is rarely necessary in a well-normalized
relational database).
If you provide more (specific) information, the 'group readers may be able
to offer more (specific) suggestions...
--
Regards
Jeff Boyce
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor