Dumb Access Question

[darrent]

I'm stuck! In Excel you can go 1,2,3 in 3 cells, select them and pull the mouse down and then by magic you have a nice column of 1,2,3,4,5,6 etc...

How do I do this in Access as the same method does not seem to work!!!

[Jinx]

Not sure if this will help but....

Go to design view add a field and define the field as "autonumber"?

[darrent]

Sorry forgot to mention that there is a six digit number (product code) in the column - I need to drag down from 694500 down to 999999!!

[tjmurphy]

Not too sure what you're trying to do (is this add a product number to data that's already there or are you setting up a whole pile of "empty" products)?

If it's a simple table, I wonder could you do a copy / paste of the data through Excel. You could only do 65,535 lines at a time but it might be quicker.

[annodomini2]

the autonumber system, creates them as you need them, so if you add a product, person whatever, you get the next number in the list.

If you want the numbers assigned by criteria, then setup an sql or vba function to define it.

[catretriever]

Bear in mind that the autonumber feature doesn't offer any guarantee that numbers will be created in sequence.

[pdV6]

catretriever said:

Bear in mind that the autonumber feature doesn't offer any guarantee that numbers will be created in sequence.

Yeah, but show me one that hasn't!

In Access, 1st create the column as an autonumnber.
Before adding any data to the table, create a query to insert the 1st value in your sequence into the appropriate column.

Then, all new records will get an auto-generated value in sequence starting from the number you first thought of.

[stuuu]

You tried creating the records in excel then cutting and pasting them into the table? usually works for me