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.
already done such numbering.
it can be done with the highest efficiency from a VBA module that would handle a counter.
if you need it as a regular query expression, it is possible to build one that will give the count of the records for which the ID is lower or equal to the current one, so that would give the line number you expect (if no duplicates). of course, that method is slower because it takes a half full scan for each line inserted.
Hello Sir, We are a group of talented professionals constituting Exotic Solutions Inc. We are willing to work on this project with you. Please check PMB for more details. Thank you.