display a certain number of records

W

wxruck

Hi, I have a problem I believe is simple but I just don't know quite how to
handle it

My database has 75000 records
I have a query based on the field called "Apprec'd". Once a date is put
into the "Apprec'd" field it has met the criteria of not being null and no
longer part of that query

My question is how can i have the query only return to me 25 records at a
time so that i only research those records. Once I research them they should
fall out of the query and the next 25 records without a null value should
appear?
 
P

Pete

You need some way of indicating that you have researched a record so I
suggest you add a yes/no field to your table that you tick when it has been
processed.

Your query will then need to be updated so that it filters on this field to
only show 'No' values.

To only return 25 records at a time you need to edit your query. Go into SQL
view and amend it so that it says:

SELECT TOP 25 instead of just SELECT
 
Top