Hi Allen,

If you could explain how to write that append query, that would be great.

Many thanks

Phil

Allen Browne wrote:
There are ways to populate the Issue table automatically when you add a new
mag. If you populate it with (say) 600 issues, that would cover the next 50
years. If you wish, I can explain how to create such an append query: let us
know if ALL your products will only ever be monthlies, of if you anticipate
the could be weeklies, quarterlies, etc.

When you are ready to send out a particular issue, you would create a query,
and type the date into the Field row, e.g.:
#1/1/2007#
Then in the Criteria row under this, enter:
Between [FirstIssue] And [LastIssue]
Specify the specific product if you wish.
The query then returns the people who should get that issue.

Thanks Allen,

[quoted text clipped - 50 lines]

Phil

--
Message posted via http://www.accessmonster.com