Using Dmax 1

[drewcp]

I am trying to create an update query that will update one table with a value created from another query

it is supposed to take my field RECID from my query Batching and update the RECID field in my Batching RECID table

here is the sql that i am using to try and do this

UPDATE Batching, [Batching RECID] SET [Batching RECID].RECID = DMax([Batching],[RECID1])+1;

when i run it, a box pops up asking for the value of batching, i am not sure how to fix, i searched through forums about the Dmax function, but have not been able to figure this out

thanks in advance if anyone can help me out with this

 

[PHV]

You wanted this ?
UPDATE [Batching RECID] SET RECID = DMax("RECID1","Batching")+1;

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[drewcp]

it works! thank you very much