Here is our problem and if anyone can help, please let me know!!! We are trying to link up the two, one from our database and covers leave perids taken and the other, under Excel format, is an allowance we pay uniquely for period on location. The dates changes all the time, the allownac is estimated in advance then adjusted the following month etc. How can we only use Access to do all of this and not have a million things to update? Any advice will be gratefully received. Murdo