 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / July 2007Auto Number set
Hi, Why when I delete a record and want to create a new record Auto number does not start from last number? any help. thx. Microsoft Access' Autonumber data type is designed to provide a unique row identifier. Nothing more. Autonumber is generally unfit for human consumption. If you care about the value of the number, don't use Autonumber! What are you trying to use the number for? There may be other approaches. Regards Jeff Boyce Microsoft Office/Access MVP > Hi, > [quoted text clipped - 4 lines] > any help. > thx. I import data into my database records contains one order and I want to know how many orders have I done so far. thx. >Hi, > [quoted text clipped - 3 lines] >any help. >thx. Create a query against the table. Click on the Totals query button. Select any field that would have data in all records. Change the "GroupBy" to "Count". You get a count of the number of records. Regards Jeff Boyce Microsoft Office/Access MVP >I import data into my database records contains one order and I want to >know [quoted text clipped - 10 lines] >>any help. >>thx. thank you for your response. I did that and in every record I got 1 instead of 1 2 3 4 5,.... >Create a query against the table. > [quoted text clipped - 16 lines] >>>any help. >>>thx. I don't understand. "1 2 3 4 5..." sounds like numbering each record. I thought you wanted a count of the number of records? Please post the SQL statement of the query. Open the query in design view, click on the view button's dropdown, select SQL, copy/paste the SQL statement. Regards Jeff Boyce Microsoft Office/Access MVP > thank you for your response. > [quoted text clipped - 20 lines] >>>>any help. >>>>thx. |
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.