I use a 6 year old program that uses Access 97 databases. I also have Access 97 and a beginners knowledge of how to use it. I want to add a number field (I know how) and use the number entered in this new field to calculate the number in another field (I do not know how).
The fields are; Code (the key, text), Order (number), and the new field will be Quantity (number).
The Quantity field will contain from zero up to 36. If the number entered in Order is 12 and the number in Quantity is zero then Order will stay zero. But if the number entered in Order is 12 and the number in Quantity is 12 then Order will become one. If the number in Order is 12 and the number in Quantity is 6 then Order will become 2. The formula would be; Order divided by Quantity.
I would appreciate any help.
The fields are; Code (the key, text), Order (number), and the new field will be Quantity (number).
The Quantity field will contain from zero up to 36. If the number entered in Order is 12 and the number in Quantity is zero then Order will stay zero. But if the number entered in Order is 12 and the number in Quantity is 12 then Order will become one. If the number in Order is 12 and the number in Quantity is 6 then Order will become 2. The formula would be; Order divided by Quantity.
I would appreciate any help.