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.
