I need to track addresses which change seasonally.  So every year CustomerA needs their winter address from Nov to Apr, and their summer address from May to October.  How would I handle this?  I have tried various things unsuccessfully.  I would like to at least track it by month, but preferably by a starting date and an ending date for each address -- but it happens every year, so is not based on a specific date.  I have looked at Richard's date functions and don't fine something along this line. Thanks for your help! Bonnie

---

Reply from Alex Hedley:

You could add a Start/End Date Field to your Address Record and put in the Dates then use a Query to get the correct address based on the chosen/current date.