View Full Version : please help


gameboy
11-21-2005, 12:17 PM
for school we have to program in access and i would like to know how to:

find out a % of one number then add the % to the orignal then put it in to a column in the table.

also i need to make the numbers going down one colunm the next number has to go up by one ever time i add a new record without using primary key and the number have start at 001,002,003 and so on.

please help i need it thank you very much jason :confused:

GaryPanic
11-22-2005, 12:56 AM
To find the percentage get your first number say 7 and the number it is a % of say 65 so (7/65) *100 so thats 7 divided by 65 * 100
to add this back onto the orgainl number you already have the number in this case 10.76923 have this a result in a field then add this and the orgianl back together in a seperate field