Phucon
A simple DELETE query (ex: DELETE FROM MyTable WHERE FirstName = 'Bill') can remove the unwanted records provided there are no child records involoved.
Are there criteria that will exclude the records? Or is it more complicated than that?
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, "cc" <saigonf7q5@...> wrote:
>
> Hello,
>
> I have a table which contains more than 2000 unique records. The ID field is the key field. My task is to separate the table, pull out the only needed records. There are 500 records need to be excluded. What's the better way to accomplish this task?
>
> Thanks
>
> Phucon
>
Tidak ada komentar:
Posting Komentar