Default Value Using DMax
Posted on 2010-11-10
I feel like this should be easy but I can't figure it out.
I have a table with these fields:
ID, VALUE, SEQUENCE
I want the Default Value for SEQUENCE to be the max value of SEQUENCE for the same ID, plus 1.
I tried DMax("SEQUENCE", "tblEntries", "ID = " & [ID]) - But Access doesn't like [ID]. Is there a way
to do this?