I have a mailing list of 100000 records, and want to query out 100 records at a time. There is no primary key in the table, and I just thought someone could help me figure out what I'm doing wrong. I know how to update the table to insure I don't keep getting the same 100 records, I just can't figure out how to pull out ONLY the first 100 records.
Access 2000, Any help appreciated.

In query Design View, open the Properties dialog and type 100 in Top Values.

Alternatively, switch to query SQL View and add Top 100 after the word SELECT i.e.
SELECT Top 100 ..........