By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,656 Members | 1,762 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,656 IT Pros & Developers. It's quick & easy.

Missing Unique Records

P: 31
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
Jun 3 '09 #1
Share this Question
Share on Google+
4 Replies


Expert 100+
P: 1,287
Thanks Fish, I tried to find that thread but gave up.
Please read the thread that FishVal linked thoroughly.
Jun 3 '09 #2

FishVal
Expert 2.5K+
P: 2,653
There was a similar thread.
Jun 3 '09 #3

P: 31
Table 1 contains
Code_No Location_Name Location_Code
1 Hyderabad 001
1
Jul 8 '09 #4

P: 31
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
Jul 8 '09 #5

Post your reply

Sign in to post your reply or Sign up for a free account.