Returning a value based on the # of records

[Guest]

RE: Access 2002

I have a table that contains 9240 records. I want to separate that data
into 88 sets of 105 records each. For example, the first 105 records are for
region 1. The Next 105 records are for region 2, etc… I was wondering if,
in a query, I could create a field named ‘Region’ and have the query return
the word “Region 1†for the first 105 records and “Region 2†for the next 105
records, etc. I could then append this to a new table, export, etc.

Any assistance would be greatly appreciated!

 

[Guest]

Add a new field called Region. Build an update query to update the field
Region with criteria Is Null. On the tool bar there is a small window that
says All. Type in 105. Enter 1 in the Update To of the grid for Region. Run
the query.

Enter 2 in the Update To of the grid for Region. Run the query.

Repeat and keep incrementing the Update To so as to update all.

 

[Guest]

Sorry - I could not get this to work because when I change the query type
from 'Select' to 'Update' the small window that says “All†is disabled.

Any additional assistance would be greatly appreciated.

 

[Guest]

If you do not have an autonumber field then add one and save. Use criteria