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] '// ======================================================= 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/
