Search results for query: unique sequential number

I think I've seen some advisement to not use calculated fields directly in tables. However, I'd still like to know if there is a way to do the following: Assign incremental sequential number by Year, i.e. YYYY-DDMM-xxx (xxx being the incremental number within the Year the entry occurs) The...

There is nothing to stop an INSERT INTO statement from inserting values from an autonumber column in one table into an autonumber column in another table, provided that the unique index on the column in the destination table is not violated. Autonumber is not a data type per se, the data type...

I have one table that gets a number of records imported into it several times a month. There are two fields I am trying to establish query programming for that will likely have to reference some VBA. I am a bit of an Access noob who sometimes has a hard time grasping how to cobble things...

IMO, a sequence number in table data is a waste. It adds friction to the process of saving a row, and provides zero return on investment. • Payoff: It does not describe when the item was created. It does not provide any meaningful sort or filter opportunities. It has no relationship to any...

No, this cannot be accomplished by a simple calc in table. Generating custom unique identifier is a fairly common topic. I had to do this for tracking laboratory samples. Samples are numbered sequentially for each year. The numbers had to be accounted for so no gaps and code deals with that...

How can I create a sequential numbering that includes month and year, and it should reset every year. Sample: 0001, 0002, 0003, and so on.... then Month, 01, 02, and so on... then Year, 2023, 2024, and so on... Shows like this: mm-sequence number-yyyy...

Thanks for the response! Doesn't Autonumber get tricky though? and there will be different SamplePeriod values and so there would be a number of multiple sequences, one per unique SamplePeriod field value. Autonumber plays well having multiple sequences per table? I always hear that it's...

OK - good to know. I vaguely recall being able to insert rows into a table with Autonumber, (including values for that field) but I also recall that things kind of got wonky sometimes - so my approach since then has been to either use Autonumber - and let it do what it wants, or don't use it...

You would have to add a sequential number column to the CSV file, but then you need a way to retain the sequence number between iterations of the CSV file (I presume), so why is it a CSV file rather than a relational table in the first place? If not a sequential number, then you need a set of...

The problem with maintaining sequential numbers is if a record is deleted you then have a gap so your numbers are no longer sequential. also, your ‘number’ will be text - which takes up more space, and given your format, will be slower to search unless you always include the month in your...

So I introduced an autonumber ([ID]) field, which no one will really see. I want to update the SeqNum field with a running number based on the ClientName field value for each existing record in my table. The autonumber value probably won't matter at all because I plan on concatenating the...

I recommend that you do NOT use "-" the dash/minus sign in any field or object name. Use a-zA-Z,0-9 and "_" in your names to reduce syntax\errors. Access/vba uses double quote chr34 " and single quote chr 39 '. Normalization is a basic tenet of relational database; should not be ignored The...

The purpose of the forum is to provide you with suggestions on how to solve a question you pose. In this case, it would appear that you are asking for a solution that circumvents the appropriate use of the autonumber field (assuming that you are using it as an autonumber field). As an...

ParentNo+lineno is not unique. There's a good chance for having the same combination in the same csv. Sorry, I can't understand what you mean by this. Do you mean opening the file with Excel and adding a column and fill it manually? Maybe the shortest way is to use a sub report instead of a...

I meant. A csv file is a text file. Simply read in the rows a line at a time and add a ", n" at the end, where n is an incrementing counter. Now you have a new column with a sequential record number.

Which is fine as far as the theory for what I want to use it for goes. Projects wouldn't have to be sequential so if a number was skipped it wouldn't matter. The only real requirement would be that it is unchanging so once a project would be assigned a number, that would be its number always and...

SELECT DCount("*", "TableX", "ParentNo & '|' & LineNo <= '" & T.ParentNo & "|" & T.LineNo & "'") + 1 AS XNo [, FieldList] FROM TableX AS T Join multiple fields for an expression that is unique. However, this field combination could also serve as a multi-field key on its own, as...

Internally, no doubt, records would be tracked with a unique primary key. Externally, anyone Perhaps now would be a good time to inform yourself about the actual software, then. I understand there are other, similar applications, like Xero which is aimed at businesses as well as individuals...

Thank you, I appreciate you spending the time to reply. However, this has been taken from an old database system the estimators have been using for years. I set up the Access one when their permissions stopped working, to work the same way , look the same etc and to their exact requirements, it...

who says they are bad? - the point of a primary key is it is unique to a record. Nobody cares (or shouldn't do) whether they are sequential or not, whether there are gaps or not. What's bad is thinking they must be sequential.