Removing Duplicate Records - Microsoft Access [ontrackTV video] 

Nice tutorial! Nice Voice!!! I googled a lot for this and nothing, so here it is, thanks!

OMG a total life saver!! Honest to God, thank you from the bottom of my heart. I watched a few other videos and wanted to fall asleep. I loved Lana's straight forward approach. I am going to watch more of her videos for sure! Yeah!!!

Makes sense :) the steps start at 3:50 for those like me who need to do this just infrequently enough that we need to use this video for reference every time,

I like your method. It worked perfectly for me in Microsoft Access 2019. I love your style!

Your way of explaining is really awesome and helpful!

Is there a reason why you would use this over the SELECT DISTINCT function in whatever query or form utilises this data set? From what I can tell it achieves the same outcome of presenting the data without duplicates, doesn’t modify the initial data set and takes a fraction of the time with far less steps

Excellent video, crisp and clear - love the walk-thru on how this is done.

Fantastic. Have spent about 20 hours on this problem and you should me how to do it straight away.

Thank you so much. The way you explained is excellent, thank you again.

This helped a lot don't know how long I been playing around with Append Queries and using Distinct etc. & this simple tutorial was all I needed... Thanks

My question is a bit different. I have a columnnar form which has 8 number fields. My condition is if Field 1 contains 1and if I put thr same number to any other fields, then the system should show a message that number 1 has already been used in one of the 8 fields in that page of the form. Same condition will apply to other pages too. I want to know is that possible in MS Access. Thnx and regards

Simple to understand! Greatly appreciate your efforts

This is exactly what I needed! Thanks

Since new table was made and new name, how this will prevent to mess up all the reports, forms, other queries that are based on the original name of the table. Also how about the relationship on other tables. Unless I rename the original table, and rename the 2nd table with no duplicates with the original name of the original table. Of course before doing all this maneuvering I would make a backup of the database first.

Can you continue to dump data into the lead list and expect the NO DUPS LIST to still work? How do you get the data to update??

Are there more lessons on Access?

What would you do if you wanted to remove all duplicates and keep the records with the earliest date? Thanks!

Very very helpful. You are the best!!! Thank you!!!

nice.very helpful video .thank you

What is the process to update the same table instead of creating a new table

thanks for the info!!! exactly what i need, although i dont like using Access that much lmao

Pro tip, watch on at least 1.5x speed.

Really useful

WOW... You're amazing 😍

Awesome and helpful!!!!!

Hey, I know you made this video a while ago, but I wanted to say thank you so much for your help. I was really struggling/panicking and this video was extremely helpful and straightforward. Thanks so much!

Thanks you! Back to work!

U r really good teach us

Not well done. For educational purposes, it would be better to cover the topic in the title as if it's not already been done by the viewer. It presumes too much.

Great tutorial.

Hey!! My name is "Lana". No wonder I understood this so easily! Great teaching!

Like the person with the comment I see now at the top, this was exactly what I needed and was easy to follow in my own database. Thanks!

Really thank you for your strong and clear instruction!

Meu Zeus! Que maravilhosa você! Me ajudou muitooo! Thank you! You are a QUEEN!

thanks alot .. but what i do if i want the data in dublicated row to merge in one row

Your explanation ia amazing you are the Best Thanks dear

thanks a lot this was really helpful

Nicely explained!! Great help. Thanks.

Thanks for the very clear explanation

Thank you so much sister 🥰🥰🥰💕

thankyou...issue resolved

i have been looking for this for months, thank you

Thank you! This helped so much!

Best teacher online

Best method so far. Thank you. Wish I had found your channel earlier

Thank you. A clever trick indeed

well explained - love this - solved my headache!

You have a very efficient and professional teaching style. I got a lot from you and your video. Thanks.