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