So, if you wanted to use this idea in a form or datasheet, let me stop and first remind you – if this is going to be non-updatable, you can just embed a report as a subreport within a form and thus use Running Sum. But let’s discuss the case where you need to be able to edit data in the forms, even with sequential numbering generated for the data you are viewing. This means we need to be able to tie a sequential number to a specific row.
OK, First, you need to reread the blog. You should NOT be storing the Transaction_ID. It is a calculated value. Second, your naming is what confused me. Your Passenger table should have an autonumber PassengerID. That PassengerID should be the Foreign Key in your Reservations table. Your servation table should also have an autonumber for ReservationID. I really don’t see why you need sequential numbering in the passenger table. I can understand it in the Reservations table, but not in the passenger table. Also, I don’t see any reason for a transaction date in the passenger table. I can understand a CreateDate for when the passenger signed up.
I am having trouble with this procedure. My situation is almost identical to example #2. I want to populate RecordNumber on my form with a date number like “130001, 130002, etc.” where “13” is the year based on a date automatically generated in the OpenDate field in tblLogRecords. OpenDate is a date/time type field that has a default value of the date the record is created and is not editable. I have added a field called Sequence to tblLogRecords and it is a Number, Long Integer type. I also created a bound control for Sequence on my form. I have a completely separate autonumber field as the PK.

Sequential exit numbering usually begins with exit 1 at the beginning of the road; each subsequent exit is given the next number. Letter suffixes are commonly used when new exits are added. For example, on the New York State Thruway, an exit was added between 21 and 22, and was given the number 21A. Subsequently, a new exit was added between 21 and 21A, leading to the sequence 21 - 21B - 21A - 22. In Florida, some new exits got the suffix C, so that if it had or acquired separate exits for the two directions, they would be 15CA and 15CB rather than 15AB. There are also occurrences of this happening on the New Jersey Turnpike; the original interchanges opened in 1951, with newer exits as recently as 1982. On the Baltimore Beltway, there is an exit 12B-C (MD 372), as well as 12A (US 1). There is also an exit 8A (I-895) and an exit 8 (MD 168).


Ok I guess it is better for me to explain what I am doing. I am in the process of creating an Access Database that an individual has been using an Excel spreadsheet forever and a day. Well the individual has on occasion doubled up numbers, forgot numbers, etc. So on what I have learned from different Access courses and Google searches I am trying to apply my knowledge.
The last option that we’ll present for assigning invoice numbers is according to project number. This is most useful for companies that take on projects where that number is the most important reference for the work. These invoice numbers will include the project number, customer number, and sequence number, with the sequence number at the end. An invoice numbering system organized by project could either begin with the customer number:
What I actually want to do, is say I go out and shoot 100 images, and I want to number them 1 to 100 so I can send them to the client and they can respond back with the number of the images they like, for instance, "Give me 21, 45, 68, and 77" as an example.  Is there a way to batch process a folder of images to sequentially number them individually, or do I have to painstakingly number them one at a time?
Hello! I already have automatic numbering set up (to change paragraph numbers automatically when paragraphs are moved within a document) but I would also like to have automatic lettering within the same document that is independent from the numbering. Example, paragraph 1 references Exhibit A, paragraph 2 references Exhibit B, so on and so forth. Currently using the above referenced method, the auto numbering lettering then follows as if the letters are a representation of the corresponding number (if that makes sense), ex: 1 B 3 C 5 D. How do I have the number sequencing independent from the letter sequence? Thank you in advance!
×