Microsoft Access 2016 Queries: Unique Values and Unique Records

Подписаться 56 тыс.

Просмотров 40 тыс.

50% 1

Microsoft Access 2016 training video on how to get Unique Values or Unique Records in your Query. The Unique Value feature is used to omit records with duplicate data in the fields displayed in the datasheet view; and the Unique Records feature is used to return on unique records based on all fields in underlying data source.
All 131 of my Access 2016 training videos contain everything you need to help pass the Microsoft Access 2016 (77-730) exam and become certified!
DVD & DOWNLOAD AVAILABLE:
(Use code "RU-vid10" for 10% OFF any download)
www.DreamForce.us
SUBSCRIBE to learn more Microsoft Office tips, tricks and shortcuts!
www.youtube.com...
LET'S CONNECT!
-- / kirt-kershaw-33874410

Опубликовано:

2 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 11

@devinpettigrew9273 3 года назад

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

@KirtKershaw 3 года назад

Welcome 😊

@keem_ 4 года назад

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

@KirtKershaw 4 года назад

Glad it worked for you! 😊

@karenschmitt1948 3 года назад

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.

@dylansalonen2825 2 года назад

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

@lukenelson9968 Год назад

Thanks a lot needed it for a computer project

@riyaadally5849 5 лет назад

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?