Missing Unique Records

[Tempalli]

I am entering records in Ms Access with a series as displayed where as i want to delete few records in this series.

Is it possible to assign the missing series to next entry.

for example i want to delete 1 and 4 in the series and i want to assign these missing series for next entry of record.

Table -1
Inventory No
1
2
3
4
5

Regards
Ananth

[ChipR]

Thanks Fish, I tried to find that thread but gave up.
Please read the thread that FishVal linked thoroughly.

[FishVal]

There was a similar thread.

[Tempalli]

Search Column Names

Table 1 contains
Code_No Location_Name Location_Code
1 Hyderabad 001
1

[Tempalli]

Update Data which matches Row data and Column Heading

In Ms Access two tables as mentioned below. In table1 the city names are mentioned in Rows and in Table2 the same city names are mentioned in column headings and the unique Ref Code is same.

Table1
Ref Code City City_Code
1 Hyd 124
1 Sec 234
1 Viz 567

I want to Update the Table2 data which matches Ref Code and Column Heading as mentioned in table3.

Table2
Ref Code Hyd Sec Viz
1


Table3
Ref Code Hyd Sec Viz
1 124 234 567

Kindly define any code for the above.

Regards,
Tempalli