I'm not 100% sure I'm following what you need, but I'll take a
guess.....you need to get 50 records at a time...if you add a new temp
field and:
1. init it to NULL
2.then select the top 50 where the new field is NULL - this will give
you the first 50
3. set the first 50 to some non-NULL char (such as 'Y')
This way you can select 50 recs at a time....
Perhaps what you're looking for is a way to compare records in a table
against themselves??? If so you can join a table to itself and compare
fields against each other - for example
Select a.*, b.*
From Table1 as a Left Join Table2 as b
On a.field1 = b.field1 and a.field2 <> b.field2.....etc.
pphelps@ups.com (Peter Phelps) wrote in message news:<45c064dd.0310210906.7eaa4638@posting.google. com>...[color=blue]
> My problem is as follows:
>
> I need automatically iterate through a single field in a table and use
> the values in the field to create an in-statement. Currently, the
> character limitation in the "Zoom" feature of the MS Access query
> builder limits the number of characters I can enter into my
> In-Statement. As a result, I need to iterate through a particular
> field (Customer ID Numbers) and use each record as a criteria in a
> query. I want to be able to:
>[color=green]
> > Step 1: Starting at record #1, create an in-statement for records 1-50
> > Step 2: For records 51-100, execute the same query and append the results to the table previously created in step 1.
> > Step 3: Without knowing how many records are in the table, iterate through the field each time running the same query and appending the results to the table created in step 1 in blocks of 50 and ending when the last record in the table is recognized.[/color][/color]
