By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,469 Members | 2,402 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,469 IT Pros & Developers. It's quick & easy.

Add one more to the highest number

P: n/a
I have field with many numbers and I wish to make by code another number
which is bigger than the highest number already in field by one. I do not
wish to use the autonumber. Can anyone help.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Me!AnotherNumber = DMax("MyField]","NameOfMyFieldTable") + 1

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Rick" <ri**@news.com> wrote in message
news:fK**************@nnrp1.ozemail.com.au...
I have field with many numbers and I wish to make by code another number
which is bigger than the highest number already in field by one. I do not
wish to use the autonumber. Can anyone help.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.