J
Jean
I've got a table that comes in each week from a remote site
(without job no's) that I need to append to an existing
table(with a sequential job no). Data is entered into the
existing table through a form which uses a formula to
increment the job no. I used the following formula in the
append query to try and increment the job no, which works
for the 1st record, but then tries to use that same number
for all subsequent records: Expr2: (Nz(DMax("JobNo","Job
Book"),0)+1) Any ideas on how to make this work?
(without job no's) that I need to append to an existing
table(with a sequential job no). Data is entered into the
existing table through a form which uses a formula to
increment the job no. I used the following formula in the
append query to try and increment the job no, which works
for the 1st record, but then tries to use that same number
for all subsequent records: Expr2: (Nz(DMax("JobNo","Job
Book"),0)+1) Any ideas on how to make this work?