Looping Update Query

  • Thread starter Thread starter Outpost
  • Start date Start date
O

Outpost

I have a table that has 2 fields that are named [CallNo] and the other
field is [ItemNo]. There are multiple Item numbers assigned to a Call
Number. I need to update the Item Numbers to be sequential starting
with 1 through ~. When it encounters a new [CallNo] it will update the
ItemNo starting with 1 and loop through until the next CallNo, and
repeat the process. TIA
 
What are the field types of ItemNo and CallNo?
Are there any duplicates of ItemNo for each call no?
Are any ItemNo equal to null (blank)?

Assuming the answers are:
Number and Number
No and
No, then you might try something like the following on a COPY of your table

UPDATE YourTable
SET ItemNo =
DCount("*","YourTable","CallNo=" & CallNo & " AND ItemNo=" & ItemNo)
 

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

Another Dlookup question 1
Simple Question on Addition 3
DSUM() 3
repeating values 1
Update Max value to another table 0
Access 2007 / update query 1
Selecting all max values of field 1 for each unique field 2 4
Update query - sequential numbering 3

Back
Top