Insert field into table and populate with numbers
Insert field into table and populate with numbers
(OP)
Arrgh, this should be easy but I can't figure it out. I have a tblMAIN with an autonumber MainID as the primary index. I've been using this field to sort my forms as it gives me the information in the order it was entered. However, I've decided to add a SortOrder field into my table so that I can make changes to the viewing order. It was easy enough to add the SortOrder field but how do I now populate it with numbers? With the table sorted ascending by MainID, I want to populate SortOrder starting at 1 and increasing by 1 until the last record. I tried making a temp table with the chronologic numbers and using an update query to insert them into tblMAIN, but it just appended the numbers instead of placing them into the existing records. Any suggestions?
Talk To Other Members
RE: Insert field into table and populate with numbers
CODE
SET [SortOrder] = DCount("*","tblMain","MainID <=" & [MainID]);
Duane
Hook'D on Access
MS Access MVP
RE: Insert field into table and populate with numbers
RE: Insert field into table and populate with numbers
RE: Insert field into table and populate with numbers
Duane
Hook'D on Access
MS Access MVP
RE: Insert field into table and populate with numbers