dbTalk Databases Forums  

SQL question

comp.database.ms-access comp.database.ms-access


Discuss SQL question in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michael Schrading
 
Posts: n/a

Default SQL question - 07-07-2004 , 04:16 PM






Hi,

I have a database with 380 records which are numbered from 0 to 380.

I would like that record no. 15 should get the number 68! or 391.

means all numbers 14 to 380 should get a new number except 68 which got
a fix number from previous 15. I would like to bring this in on simple
query.

Is this possible?

Thank you for any help
Michael




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.