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 :)
Printable View
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...