can you copy and increment numbers in access 2007
Discussion
JDMFanYo said:
2 ways
Let's use column A for example
1)
In A1 you have the original value
In A2, place the value =A1+1 (replace A1 with whatever cell you are starting with, it might be E36).
A2 (or whatever cell you chose) can then be copied downwards
2)
When A1 is highlighted, click and drag the little square which appears in the bottom right of the highlighted cell. this doesn't always work, as sometimes just duplicates the entry in 1.
That's Excel, not Access.Let's use column A for example
1)
In A1 you have the original value
In A2, place the value =A1+1 (replace A1 with whatever cell you are starting with, it might be E36).
A2 (or whatever cell you chose) can then be copied downwards
2)
When A1 is highlighted, click and drag the little square which appears in the bottom right of the highlighted cell. this doesn't always work, as sometimes just duplicates the entry in 1.
Edited by JDMFanYo on Monday 15th February 17:32
Don't know much about Access personally but couldn't you make the field an 'Autonumber' data type, then Access will add 1 to the number every time you do an insert. I think....
mouseymousey said:
JDMFanYo said:
2 ways
Let's use column A for example
1)
In A1 you have the original value
In A2, place the value =A1+1 (replace A1 with whatever cell you are starting with, it might be E36).
A2 (or whatever cell you chose) can then be copied downwards
2)
When A1 is highlighted, click and drag the little square which appears in the bottom right of the highlighted cell. this doesn't always work, as sometimes just duplicates the entry in 1.
That's Excel, not Access.Let's use column A for example
1)
In A1 you have the original value
In A2, place the value =A1+1 (replace A1 with whatever cell you are starting with, it might be E36).
A2 (or whatever cell you chose) can then be copied downwards
2)
When A1 is highlighted, click and drag the little square which appears in the bottom right of the highlighted cell. this doesn't always work, as sometimes just duplicates the entry in 1.
Edited by JDMFanYo on Monday 15th February 17:32
Don't know much about Access personally but couldn't you make the field an 'Autonumber' data type, then Access will add 1 to the number every time you do an insert. I think....
Autonumber column it is then
Edited by JDMFanYo on Tuesday 16th February 08:49
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff