In MS Access 2007 on the query tab:
What I'm trying to do is compare the value in one field to the next value in the same field.
So the query would look something like:
Field: address
table: customer
update to:
criteria: address + 1
So I'm comparing the address to the next...