J JBurlison Registered User. Local time Yesterday, 22:40 Joined Mar 14, 2008 Messages 172 Apr 18, 2008 #1 i need to automaticly Generate a Primary key for RMA Numbers so i want Previous forms number + 1 and i want to start with Number 10832.
i need to automaticly Generate a Primary key for RMA Numbers so i want Previous forms number + 1 and i want to start with Number 10832.
boblarson Smeghead Local time Yesterday, 19:40 Joined Jan 12, 2001 Messages 32,040 Apr 18, 2008 #2 Look into the DMax function.
J JBurlison Registered User. Local time Yesterday, 22:40 Joined Mar 14, 2008 Messages 172 Apr 21, 2008 #3 im confuesed as to how to apply it do i put it in a query or VBA, Dmin ("Column Name", "Table Name", Min Value) how do i apply this method?
im confuesed as to how to apply it do i put it in a query or VBA, Dmin ("Column Name", "Table Name", Min Value) how do i apply this method?