distinct query help

i'm in need of help woth this query, i've edited my post.

just click the link below

http://www.geocities.com/gateofgalesph/qry/index.html

thank you :)

The query did return distinct records just as you had asked for. What exactly are you looking for it to return? Distinct customer IDs?, Last names?, etc... by including all of the fields behind the 'Distinct' keyword you are only filtering records where all of the fields are the same. If one field is different (ie. your 'tcno' fields) that is a separate 'Distinct' record...