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,
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
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!
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
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
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.
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.
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
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!!!
Hey!! My name is "Lana". No wonder I understood this so easily! Great teaching!
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,
Thank you so much. The way you explained is excellent, thank you again.
Nice tutorial! Nice Voice!!!
I googled a lot for this and nothing, so here it is, thanks!
Your way of explaining is really awesome and helpful!
I like your method. It worked perfectly for me in Microsoft Access 2019. I love your style!
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
ruclips.net/user/MsAccessVbaCode
Excellent video, crisp and clear - love the walk-thru on how this is done.
ruclips.net/user/MsAccessVbaCode
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!
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!
ruclips.net/user/MsAccessVbaCode
Best teacher online
This is exactly what I needed! Thanks
Fantastic. Have spent about 20 hours on this problem and you should me how to do it straight away.
ruclips.net/user/MsAccessVbaCode
i have been looking for this for months, thank you
Simple to understand! Greatly appreciate your efforts
ruclips.net/user/MsAccessVbaCode
Very very helpful. You are the best!!! Thank you!!!
Best method so far. Thank you. Wish I had found your channel earlier
ruclips.net/user/MsAccessVbaCode
Really thank you for your strong and clear instruction!
ruclips.net/user/MsAccessVbaCode
Your explanation ia amazing you are the Best Thanks dear
WOW... You're amazing 😍
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
What would you do if you wanted to remove all duplicates and keep the records with the earliest date? Thanks!
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
ruclips.net/user/MsAccessVbaCode
well explained - love this - solved my headache!
ruclips.net/user/MsAccessVbaCode
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.
Are there more lessons on Access?
You have a very efficient and professional teaching style. I got a lot from you and your video. Thanks.
Thanks for the very clear explanation
thanks alot .. but what i do if i want the data in dublicated row to merge in one row
Nicely explained!! Great help. Thanks.
nice.very helpful video .thank you
Awesome and helpful!!!!!
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??
Thanks you! Back to work!
thanks a lot this was really helpful
Thank you so much sister 🥰🥰🥰💕
What is the process to update the same table instead of creating a new table
Great tutorial.
U r really good teach us
thanks for the info!!! exactly what i need, although i dont like using Access that much lmao
Meu Zeus! Que maravilhosa você! Me ajudou muitooo!
Thank you! You are a QUEEN!
ruclips.net/user/MsAccessVbaCode
Really useful
Thank you! This helped so much!
Thank you. A clever trick indeed
thankyou...issue resolved
Pro tip, watch on at least 1.5x speed.
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.