Different addresses must be accessed depending on time of year.
in [Reports]
|
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 news:60B5B2A7-31BF-4C5A-9CFF-64F1F8BD35D0(a)microsoft.com... >>>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 > criteria > Between SeasonStart AND SeasonEnd > > -- > Build a little, test a little. > > > "Judith9" wrote: > >> Mailings from this seasonal community need to go to different addresses >> for >> individual members depending on whether the members are still in the area >> or >> have returned to their winter homes. I suspect that queries will play a >> role >> 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 >> addresses? |