Hello,
Here is my SQL Statement:

SELECT TOP 100 PERCENT fax_number, fmf_path, customer_name, customer_contact, cover_page, hard_copy, fax_status, server, insert_date, original_date, attempts, counter
FROM dbo.fax_data
ORDER BY insert_date


My primary key is the counter field. What I want to do is make this query show only once instance of a certain fax_number. I don't want repeating fax_numbers in my result. I don't even know where to start with this. Any help would be greatly appreciated...

Thanks!!!

MAC