Access VBA code to work out range of numbers There was a recent question on the litsupport group about how to make up a range of ‘bates numbers’ e.g. In two fields you have: DocID BatesNo A00001 A00001 A00001 A00002 A00001 A00003 A00001 A00004 And what you actually want is one record stating: DocID BatesNos … Continue reading Bates Numbers