From: John... Visio MVP on 23 Dec 2009 08:26
You should add a fudge factor to allow for mail processing. If you are
within a week of a change of address, then send it to the next address.
John... Visio MVP
"KARL DEWEY" <KARLDEWEY(a)discussions.microsoft.com> wrote in message
>>>Do I set up separate tables for summer and winter addresses?
> No, add two DateTime fields for SeasonStart and SeasonEnd.
> Then your query to have calculated field -- Todays: Date() and
> Between SeasonStart AND SeasonEnd
> Build a little, test a little.
> "Judith9" wrote:
>> Mailings from this seasonal community need to go to different addresses
>> individual members depending on whether the members are still in the area
>> have returned to their winter homes. I suspect that queries will play a
>> in this, but I also imagine that the tables need to be set up with this
>> requirement in mind. Do I set up separate tables for summer and winter