Search results

JZWP22, many thanks for your answer. I had worked a solutiuon in the mean time which is similar but, given my lack of realy expertise in Access, perhaps not as efficient as yours. Would you please comment. When the user presses the New Record button I run a Make-Table query with the folowing...

Sorry if there is already an answer to this but I couldn't find it. I manage a membership database where the membership number is the key. As members die, retire or simply resign their membership number becomes vacant. I would like to be able to reallocate these blank numbers automatically when...