Pulling a set of records

[john jacobs]

I have a large table in Access 2003 where I am searching for a specific piece of criteria in one of the rows. When it finds this criteria I need the database to take this row, as well as the next four rows, and place them into a new table. Is there anyway this can be done?

[nico5038]

First make a select query setting the criteria and then change the query type into a "MakeTable" or "Append" query.

Nic;o)

[NeoPa]

John Jacobs:
When it finds this criteria I need the database to take this row, as well as the next four rows,

How would you define the next four rows, bearing in mind this has no meaning within an RDBMS without a defined context. Records are not stored in any predefined order.

[nico5038]

Good point NeoPa, it can be delivered when there's a sequence by using the TOP 5
But without a sequence or relation defined in a field it's not possible to get a "stable" set.

Nic;o)

[John Jacobs]

I have it set to automatically add a primary key each time the file is imported. The only problem is depending on whether or not data is added or taken away on the source file could alter the record number the criteria I am looking could be on. Once a select query finds the criteria, is there anyway to tell it to pull the next four rows based on the primary key?

[NeoPa]

John Jacobs:
Once a select query finds the criteria, is there anyway to tell it to pull the next four rows based on the primary key?

Yes. I refer you back to the previous post (#4) where the approach is outlined for you.