Create field default using the ID field in Access 2007

J

JimG

I am setting up an existing Access 2007 database on Sharepoint which assigns
a new ID field. Problem is all our databases have a 6 or 7 digit ID which
match a claim file number. We tried to use the ID field + a 6 or 7 digit
number as a default (= [ID] + 600000) in the claimID field that updates when
a new row is created but Access reports an error "the field [ID] does not
exist etc." I have tried =Nz(DMax("ClaimID","Claimant",""),0)+1 and
=Nz(DMax("ID","Claimant",""),0)+1 as a default. Both result in a error
message that "Nz" is an unknown function. Help!!

Thanks
 

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

Autonumber field in Excel that behaves the same as Access 0
Errors in Autonumber ID field 4
Using Sharepoint Lists as tables 4
Running balance for debit and Credit using query in Access 2007 0
String with Varying Letter followed by Incremented Number 3
Access ID 3
Problem using Date() for default value in my Date/Time field 4
DMax on existing record to increment serialized # fails 1

Top