increment field value

G

gator

I am using < Max([CheckNumber])+1 > as default value in field property on
form. There are already several records with values in CheckNumber. The
default that is displayed in the new record is 1. Why won't this just add 1
to the highest number?
DMAX([CheckNumber]) + 1 gives the same result...
 

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

Show highest. 1
Increment Numbers increasing 2 at a time 5
Increment number 3
Incremental Check Numbers 7
Zeros 1
Simple Access Project - Almost There Just Need Some Help... 2
Increment a Short Time Field by 15 minutes 2
DMax on existing record to increment serialized # fails 1

Top