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 :P
But i need a separate table where the entry of all the entries where a is coming only once.
Can this be possible.

[June7]

Not sure I understand.

You need this data separated into Customers and Orders tables?

SELECT [Name], [mail no], [contact no] GROUP BY [Name], [mail no], [contact no];

[drunkenneo]

Not sure I understand.

You need this data separated into Customers and Orders tables?

SELECT [Name], [mail no], [contact no] GROUP BY [Name], [mail no], [contact no];

I need the result to be:

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

only distinct order number

[offie]

So you want to delete duplicates? You can run a query wizard to find them.
If you want it alphabetical then go back into the design view and and make the Name field sorted by "Ascending"

[June7]

Selecting distinct order_no would be easy. However, all fields must be considered in determining uniqueness of record. Mail_no is different for each record. Why did you delete mail_no 2344?