Hi holt I am not as perfessional coder. though i hope i could help you. please ignore if i am worng. well you will store all the table value in a recordset. in a do loop you could check for the occurrence of the part no. and when it is true delete that current record and come out of the loop. i hope no sql command is req.
regards viswanathan --- Julian Holt <[EMAIL PROTECTED]> wrote: > Hi > > I am using access ----- a trawl round t'internet > has revealed nothing. > > Looks like this is an incredibly difficult and > highly unusual thing to want > to do :-) > > Just to clarify further > > I have a table like this > > PartNo Description > 111 Hello > 123 Hello > 456 World > 123 Hello > 123 Hello > 123 Hello > 123 Hello > > I want to delete the first occurrence of "123 > Hello" to leave > > PartNo Description > 111 Hello > 456 World > 123 Hello > 123 Hello > 123 Hello > 123 Hello > > All the SQL I have tried to date would either delete > all occurrences of "123 > Hello" or delete all repeated occurrences to leave > > PartNo Description > 111 Hello > 123 Hello > 456 World > > TA > > Julian > > > -----Original Message----- > From: m50h [mailto:[EMAIL PROTECTED] > Sent: 11 May 2004 19:56 > To: [EMAIL PROTECTED] > Subject: [vbhelp] Re: Simple database question (I > guess) > > > Dear Julian Holt > > if you want to do this first of all you have to > specify your database > format and after specifying that then we can offer > you a way for > doing that. > for example may be your database format be > mdb(access) or text in > binary or other things. > > Good luck > Mohsen. > --- In [EMAIL PROTECTED], "Julian Holt" > <[EMAIL PROTECTED]> wrote: > > Guys > > > > I have a database looking something like this, > > > > PartNo Description > > 111 Hello > > 123 Hello > > 456 World > > 123 Hello > > > > I want to detect the first occurrence of a given > PartNo (say 123) > and delete > > the whole row from the DB > > > > So for example I want to delete the row "123 > Hello" given > the PartNo > > 123 > > > > I guess its SQL but I am not too sure what to do > > > > > > Any ideas? > > > > > > Many thanks > > > > Julian Holt > > > > > > [Non-text portions of this message have been > removed] > > > > > > '// > ======================================================= > Rules : > http://ReliableAnswers.com/List/Rules.asp > Home : http://groups.yahoo.com/group/vbHelp/ > > ======================================================= > Post : [EMAIL PROTECTED] > Join : [EMAIL PROTECTED] > Leave : [EMAIL PROTECTED] > '// > ======================================================= > > > > > ---------------------------------------------------------------------------- > -- > Yahoo! Groups Links > > a.. To visit your group on the web, go to: > http://groups.yahoo.com/group/vbhelp/ > > b.. To unsubscribe from this group, send an > email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the > Yahoo! Terms of Service. > > > > [Non-text portions of this message have been > removed] > > ===== Thanks & Regards Viswanathan R __________________________________ Do you Yahoo!? Yahoo! Movies - Buy advance tickets for 'Shrek 2' http://movies.yahoo.com/showtimes/movie?mid=1808405861 '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
