Microsoft Access 2016 Queries: Unique Values and Unique Records

[@dylansalonen2825]

This was beyond helpful for an assignment of mine! Thank you much.

[@devinpettigrew9273]

Thanks for clearing this up. I was about to tear out my hair.

[@KirtKershaw]

Welcome 😊

[@keem_]

I was stuck in a complicated spot and you solved my problem in the first minute

[@KirtKershaw]

Glad it worked for you! 😊

[@riyaadally5849]

Thanks for the Kirt. This very helpful, I have a question related to your video. would it be possible to number the Duplicate, such that we have a row wherein the 1st instance of the duplicate is numbered one, the second is labeled two and so forth?

[@lukenelson9968]

Thanks a lot needed it for a computer project

[@karenschmitt1948]

I am following what you are doing exactly and its still putting duplicate departments. I have department column and sales $ and am guessing its because of the sales $, but I need to total the sales by department so i can't delete. UGH.

[@simretgoitom8500]

Thanks. My issues has resolved.

[@jmm4963]

thanks!

[@KirtKershaw]

Welcome 😊