Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.pagelayout
new new is offline
external usenet poster
 
Posts: 3
Default How can I remove duplicate records?

I am not a big user of Access and I need quick help.

I have a table with 2 columns: tbl_Supplier (SupplierID, SupplierName)

The data for 1st column was obtained via a query (from tbl_Products
which provide SupplierID); the data for the second column was to be
populated manually but at the moment has Null value.

I want to make SupplierID to PK once I removed duplicate records. I
have 77 records now but should be 29.

Any help?

 
Thread Tools
Display Modes

Posting Rules

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove duplicate text lines in a Word doc Lili Vivanco Microsoft Word Help 8 April 24th 23 02:51 PM
not merging duplicate records dan Mailmerge 8 March 14th 06 08:52 PM
Duplicate Records Merging with Access markmidwest Mailmerge 3 June 13th 05 07:10 PM
Duplicate records based on spreadsheet data being merged? Digger Mailmerge 1 April 25th 05 09:00 AM
Remove duplicate entries. ramcam6 Microsoft Word Help 1 February 6th 05 01:03 AM


All times are GMT +1. The time now is 03:39 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"