Making Table Query

[Drunkenneo]

Here i have a situation i have a table where like below

Name | orderno | mail no | contact No |
---------------------------------------
a |123 |5555 | 553453 |
b |321 |8569 | 52353 |
a |123 |2344 | 553453 |
c |143 |567 | 553453 |
d |173 |6787865| 553453 |

Bad table
But i need a separate table where the entry of all the entries where a is coming only once.
Can this be possible.

 

[Cronk]

I don't understand what you want to go into Table 2.

Can you provide what would be there using the records shown in your post.

 

[Michael3Smith]

You can make a table with the same fields, but set the Filed Property "Indexed" to "Yes (No Duplicates)" for the column you named "Name" (I would suggest you change the name to something like "FileName" or something other than just "name").

Append the data to the new table and only ONE instance of any record will be added. The result from your sample data would be:

Name orderno mail no contact No
a 123 5555 553453
b 321 8569 52353
c 143 567 553453
d 173 6787865 553453