So i have a table with lets say four fields on table1
i need to update the sequence grouping the fields by the other three fields.
so if there are 4 records where Date, Group and Status are the same, the Sequence_number would start at 101, 102, 103, 104 then start again at 101 for the next group of records where these three fields are the same.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple. The final solution for this task involved creating a custom text parser and then reading…