Landy
One quick way would be to create a new number field called Rank. Then
your Find script which finds those records with an empty Mailed_Date
would also include serializing the contents of Rank of the found set and
then constraining this found set to records with Rank < 151.
Perform Script [FindIsEmpty(Mailed_Date)]
Replace Field Contents [No dialog; File::Rank; Serial numbers]
Constrain Found Set [File::Rank < 151]
Ross
Landy Atkinson wrote:
I have a database of 5000+ addresses which can be grouped into 3
territories based upon state, Western, Central and Eastern. We want to
send a mailing to about 150 in each region each month until the list is
used up. {if we sent more, the sales people could not keep up with the
follow-up activities.} I can easily perform a query to pull up a list
of addresses in each region which have not received a mailing (I set up
a Mailed field and a Mailed_Date field which will be filled in at each
mailing), but I am not sure of a good way to limit the result list to
the first 150 found so it can be used to print mailing labels and mark
as Mailed.
Do I have to do this with a loop and counter in a script or is there a
way to select records 1 to 150 (or for that matter 40 to 80, etc.) in
the found set directly as part of the query or with another "limit"
command. Seems like being able to pick a subset of a query to "display
by page" would be a generally useful task that is complicated by having
to use a script.
Any suggestions of how best to approach this are welcome.
