 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / February 2008Add Records Sequentially with DMAX
Where is the proper place in my form to add the following Area Table CostCodeLast3 CostCode 1000 001 10-001 1100 001 11-001 1200 001 12-001 002 12-002 003 12-003 I want the next cost code to pop up after I enter the area in a new record. I know how to combine the last 3 with the first 2 numbers of the area. I don't know how to make the code select the next last 3 for area. Dan, I don't know the what the Dmax is for but if you are looking for concatenation put this in a query: CostCode: left([area table];2)&right(CostCodeLast3;3) That should give you the outcome you are looking for. hth  SignatureMaurice Ausum > Where is the proper place in my form to add the following > [quoted text clipped - 8 lines] > I know how to combine the last 3 with the first 2 numbers of the area. > I don't know how to make the code select the next last 3 for area. I probably didn't explain clearly. I can do the concatenation, but first I need to add to the previous number when I add a new record. 001, 002, 003 based on selecting the areas. I have 10 areas and each starts at 001. I need the form to go find the last number for that area. ie. 12-301 add new record 12-302. I >Dan, > [quoted text clipped - 11 lines] >> I know how to combine the last 3 with the first 2 numbers of the area. >> I don't know how to make the code select the next last 3 for area. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.