A new field to number records to a maximum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large database of students. The system should create a a new field
"Assigned" to assign the students numers to a certain maximum, say 12.
The first 12 on the list will asume 1, 2, ...., 12
The next 12 will assume 13, 14, ...., 24
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A new field to auto insert numbers 1
Selecting one of duplicate records with a maximum value. 5
show top values 5
Update Query 3
Move Column data to row data 2
Headache on Outer Join with Crosstab 1
Advanced problem using auto-number and datediff to find readmissio 1
Use table fields as records 5

Back
Top