Access table build

Number records when appended into a second table. Details: We need to select no more than the first 8 records from 'tblPrograms Master' (see the criteria in 'qryEucharist Positions Append') and append them to 'tblEucharistPositions' in the same order. The field 'PositionID' in 'tblEucharistPositions' must contain 1, 2, 3, etc. for each record. This process will be repeated after deleting the contents of 'tblEucharistPositions' (see 'qryEucharist Positions Delete') and reloading the data. The field PositionID must always start at 1. The operator cannot use the compact and repair database utility therefore PositionID cannot be an AutoNumber.