Get max out of table and replace all zero by max+1

[Kweker]

Is it possible to find all the fields(schoolID) out of table scholen that are zero, then select a few or all of these records, then find maximum [schoolID] and fill the selected [schoolID]."table scholen" with each time maximum number + 1

 

[AlexMidd]

Use an update query on the scholen table with the schoolID field in the grid. set the criteria box to "=0" and the update to box to "Max([schoolID]) +1". Run the query. (N.B. backup the database or table first as the query, once run, is not reversible). Have fun! )

Alex Middleton