Hi,
I have a culum in acces, where multiple records stored. (e.g. Nokia, Nokia, Nokia, Sony, Erricson etc)
What I am looking is instead of showing 3 times of Nokia, I want it to show just once. How can I restrict my records like that?
Please any friend advice/tutorial/extension like that. Would be greatful.
Thanks

Babu

SELECT DISTINCT column_name FROM table_name

This should have gone under SQL/Dreamweaver <img src=../images/dmxzone/forum/icon_smile_dissapprove.gif border=0 align=middle>

Yup - janusz.co.uk

Thanks

Hope it will work - it will make my project much easier.

I will give a try.



Babu

Edited by - babui on 29 Oct 2004 14:53:53