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