On 13/02/2007, at 12:58 am, Landy Atkinson wrote:
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.
If your search is for only those records who haven't received a
mailing yet, then it seems to me like you'll only need to limit the
found set to the first N records (because once those have been
printed, you'd presumably set the Mailed flag). So just Omit the
remainder of the records:
1. Go To Record 151
2. Omit Multiple records, with a large number (eg, 999999) and
remember to "Perform without dialog"
--
Tim Mansour <[EMAIL PROTECTED]>
Neologica Print & Promotions (ABN 63 904 335 408)
159 Commonwealth Street Surry Hills NSW 2010
Sydney 02 9212 1789 Melbourne 03 9012 7441 Mobile 0405 500 846