I did not get my Solution at Advanced ASP Section.

Results 1 to 2 of 2

Thread: I did not get my Solution at Advanced ASP Section.

  1. #1
    Sharron Lily Guest

    Default I did not get my Solution at Advanced ASP Section.

    Hello Friends , <BR>This is my first time at this site reffered by a friend i hope you guys could help me out. <BR>I have a table in MS Access having many fields. <BR>The fields are Part_numbers,Office,Pool_ID,Bin_Location,ESC...etc . <BR>There are 7000 rows.Out of this 7000 rows around 2000 rows contains duplicate part_numbers.I want to remove the Duplication of part numbers. example.. <BR>Below Table name is &#039;Inventory.mdb&#039;: <BR>-------------------------------------------------------------- <BR>part_numbers, Office, Pool, Bin, ESC,... <BR>-------------------------------------------------------------- <BR>00436-60008, D400, J9013, XYZ, $500 <BR>00436-60008, D476, J9014, XYZ, $500 <BR>______________________________________________ ________________ <BR>Maximum number of repeatation of a single part_number is three. <BR><BR>SO WHAT I CAN DO IS,mearge the table i mean, i can have additional fields like Office_2,pool_2 and so on. ie... <BR>&#039;Solution.mdb&#039;: <BR>-------------------------------------------------------------- <BR>part_numbers, Office, Office_2, Pool, Pool_2, Bin, ESC . <BR>-------------------------------------------------------------- <BR>00436-60008, D400, D476, J9013, J9014, XYZ, $500 <BR>______________________________________________ ________________ <BR><BR>For getting the above (which is my requirement) i have to first create two or three tables from the inventory table and keep all the duplicate part_numbers row in different tables.Then run a query to get a common solution.mdb table. <BR>So my question is how split the &#039;first table ie.. &#039;inventory.mdb&#039; in to two or three tables on the basis of the duplicate part_numbers.Tell me if SQL alone can solve it without using ASP(even better).Else how to do it using ASP.My database is of Access. <BR>Regards and Love, <BR>Sharron Lily. <BR><BR><BR>

  2. #2
    Join Date
    Dec 1969


    see ASP forum.<BR><BR>j

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts