Access 2007 Tutorial 5.3. Delete Duplicate Records
Loading...
Loading...
19,418
Loading...
There is no Interactive Transcript.
Uploader Comments (djdates)
see all
Video Responses
This video is a response to Access 2007 Tutorial 5.4. Inserting into multiple fields using a Combo box and NotInList Event
see all
All Comments (4)
-
I understood what we did in video 5.1 and 5.2 and I understand what the goal is in 5.3, I am just not understanding how we arrived at the solution and I have watched this 3 times.
We went from 72 records, then allowed duplication via properties and went to 342 records, then to 67, then back to 72. Let me watch this a 4th time.
Definitely NOT beginner video. Thank you so much for sharing your knowledge.
-
SWEET VID
Loading...
4:27
How to Find & Remove Duplicate Records in Excel 2007by DannyRocksExcels5,222 views- 8:27
How to Generate Multiple Reports from One Pivot Tableby DannyRocksExcels3,755 views
- 2:37
Access - Find Duplicates Queryby susanthrall1,956 views
- 9:08
Option Buttons and Check Boxesby professorcindy4,409 views
- 4:16
Access 2007 - creating formulas/calculations in a queryby alanbweaver23,774 views
- 8:21
Access 2007 Tutorial 4.1 Reportsby djdates32,008 views
- 3:13
Inputting Data using a Formby MegaHardie11,008 views
- 9:35
Access 2007 Tutorial 2.1. Importing Databy djdates22,190 views
- 9 videosAccess 2007 djdates
- 0:40
How to write sql in Microsoft ACCESS 2007by kirkigr17,613 views
- 3:39
Access - Append Queryby HugoPhongPresents13,088 views
- 2:52
Access 2007 Tip: Creating Queriesby AtHandServices34,042 views
- 15:28
Access 2007 Tutorial 5.4. Inserting into multiple fields using a Combo box and NotInList Eventby djdates7,586 views
- 17:00
Microsoft Access Tutorial for Beginners #1 - Overview (Access 2003)by MotionTraining59,937 views
- 5:55
Access 2010 Tutorial The 'Find Duplicates' Query Microsoft Training Lesson 9.6by teachucompinc1,549 views
- 3:16
Computer Literacy: Binary Decoder Wheelby djdates1,822 views
- 9:26
Relationships - "One To Many" relationshipby FmTutorials66,022 views
- 6:57
Access 2003 Tutorial Sorting and Grouping Data in Reports Microsoft Training Lesson 14.4by teachucompinc18,176 views
- 5:55
Access 2007 Tutorial 5.1. Many to Many Importby djdates12,148 views
- 2:42
Microsoft Access Query Formulas Combining Fields, Arithmeticby myaccessprogram57,417 views
- 7:41
Access 2007 Tutorial Designing Queries Microsoft Training Lesson 7.2by teachucompinc66,250 views
Can this only be done on Primary Key? I tried on a field that is not a primary key and the query never finishes. I see running query but the progress bar never shows up.
RogueX20 8 months ago
@RogueX20 I'm sorry, but I am not exactly sure what you are asking. We use the PK in the delete query because it gives a unique identifier for the record when we want to delete it. If you have another identifier that you are confident is unique, you could use that.
If you are having a problem with your query, try making it as simple as possible and then add complexity, so you can determine exactly when it starts to go wrong.
djdates 8 months ago