There are no triggers in Access, afaik.
You could create a macro for this, that populates the third field with the difference of the two, but I'm not familiar with VBA.
But hey, at least it'll lead you in the right direction.
And my condolences for the "degradation" to Access![]()




Reply With Quote