Win Web Hosting

I cannot imagine why you would want to implement such a design.

However, create a variable to hold the result of the dividing the amount by the quantity. Next, use a FOR/NEXT loop based upon the quantity entered. In the loop insert a record into the database. Access will automatically increment the assetid field, so you only need to provide the result of the amount/quantity operation by using the variable calculated at the beginning of the process.