Dear Bryan,
Thanks a lot. You were very helpful.
Best wishes
Bill
--- In [email protected], "stomper57" <[EMAIL PROTECTED]>
wrote:
> Hi,
> If your table's primary key datatype is Autonumber, you
> could use a Domain Aggregate Function in the WHERE clause
> of your query.
>
> WHERE
> (
> [ID]
> BETWEEN
> DMin("[ID]","[Table_1]")
> AND
> DMin("[ID]","[Table_1]") +
> [How many do you wish to delete?]
> )
>
> You could also have this on a form and replace:
> [How many do you wish to delete?] with Forms!frmMyForm.text1
> This way you could do validation and a confirmation
> before deleting.
>
> Bryan
>
> --- In [email protected], "billkond" <[EMAIL PROTECTED]>
> wrote:
> > Dear Friends,
> > Is it possible to have a deletion (erasure) query who asks me how
> > many(each time defined by me) of the FIRST records wish to delete from
> > a table?
> > For example : 'Do you want to delete the FIRST [...] records from the
> > Table_1?' So, if i type 10 then the first 10 records from the Table_1
> > will be deleted. If i type 8, the first 8 records from the table will
> > be deleted e.t.c.
> >
> > TIA
> > Bill
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> 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/
