CREATE A CERTAIN NUMBER OF RECORDS WITH AUTONUMBER

[georg0307]

Dear all,
I would need a field where specify a certain number of records destined to print labels (rptLabels). The Trolley (SKU) field is "Autonumber", while in "NR" I would like to be able to enter the number of unique records to be created. Attached the Database. Thanks in advance to anyone who wanted to help me. For I.E:

NR: 20

The result should be:

TROLLEY
10000000
10000001
10000002
10000003
10000004
10000005
10000006
10000007
10000008
10000009
10000010
10000011
10000012
10000013
10000014
10000015
10000016
10000017
10000018
10000019

Best regards,
Georg B.

 

[arnelgp]

you need to Modify the Report since it uses my printer.

 

[arnelgp]

SKU should be Short text rather.

 

[georg0307]

Ciao,

thanks for the help, just a little thing because I print several times and I need to maintain uniqueness number, I mean:

first time I print 25 labels... starting 10000004 to 10000029

next time I print 11 labels... starting 10000029 to 10000040

... so and so

Sorry for my terrible English, I hope you understand..

 

[arnelgp]

See post #1. It is based on initial sku. So it you printed 10 for the sku, to print the next 10, chng the sku to orig sku+10.

 

[georg0307]

Hi,

thanks for prompt reply, I need really something very simple, an autonumber field and e a second field where I outnumber of label I want print.
This mean that the next time I go to print the autonumber may start form the last number created + 1.

Sorry if my English is not so good, I hope you understand me...

Thanks Best regards,

Georg