Auto Number increment by 2

T

Tracey

I need to set up a database with a unique field/ID field
that is generated automatically when data is recieved from
an online form. Now AutoNumer is Ideal excepted I need it
to increase by 2 each time and not 1. Eg. 1,3,5,7,9,11
etc. Can anyone suggest a way of doing this.

I'm a real basic Access user so please be gentle with me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Increment composite key 1
create an Auto-increment field for use as the primary index betwee 1
Simple Auto increment 0
Auto-Increment Issue (couldn't find this one) 4
Increment Account Numbers 1
Auto Increment by 1 Letter 3
Auto Increment recordset 4
DMax on existing record to increment serialized # fails 1

Top