Hello everyone!
Is out there any way to search for duplicate entries without using the "Find duplicates" option? In the Access 97 installed in my workplace, the Find duplicates option is disabled (don't ask me why) and I think that there are little chances of having it installed. Any wonder of how to overcome this situation without the aforementioned wizard?
Thank you very much in advance
Best regards from Barcelona
5 8279
Hello everyone!
Is out there any way to search for duplicate entries without using the "Find duplicates" option? In the Access 97 installed in my workplace, the Find duplicates option is disabled (don't ask me why) and I think that there are little chances of having it installed. Any wonder of how to overcome this situation without the aforementioned wizard?
Thank you very much in advance
Best regards from Barcelona
The find duplicates query is set up in this format: You should be able to modify it for your needs. -
SELECT Table1.Field1, Table1.Field2
-
FROM Table1
-
WHERE (((Table1.Field1) In (SELECT [Field1] FROM [Table1] As Tmp GROUP BY [Field1] HAVING Count(*)>1 )))
-
ORDER BY Table1.Field1;
-
Hope this Helps,
Bender
The find duplicates query is set up in this format: You should be able to modify it for your needs. -
SELECT Table1.Field1, Table1.Field2
-
FROM Table1
-
WHERE (((Table1.Field1) In (SELECT [Field1] FROM [Table1] As Tmp GROUP BY [Field1] HAVING Count(*)>1 )))
-
ORDER BY Table1.Field1;
-
Hope this Helps,
Bender
Bender, first and foremost, thank you very much for your help!
I don't have much idea of SQL language, but this code looks like the one behind a Totals query. Am I right? Anyway, does this code enable Access to discriminate between, say, two Customer Names that, being in fact the same, differ from, say, a single or a couple of characters/numbers? I suspect that with this SQL code, this case would not be detected.
My question is, does the Find duplicates query/wizard discriminate between two records that are very similar, that is, does Access gives you a tip like: "hey, this two records have a 95% or more of similarity. Could they be a duplicate entry?"??. I don't know if this is possible, since, as I stated before, the Find duplicates option is disabled at my 97 Access.
Thank you in advance!!
Best regards
Bender, first and foremost, thank you very much for your help!
I don't have much idea of SQL language, but this code looks like the one behind a Totals query. Am I right? Anyway, does this code enable Access to discriminate between, say, two Customer Names that, being in fact the same, differ from, say, a single or a couple of characters/numbers? I suspect that with this SQL code, this case would not be detected.
My question is, does the Find duplicates query/wizard discriminate between two records that are very similar, that is, does Access gives you a tip like: "hey, this two records have a 95% or more of similarity. Could they be a duplicate entry?"??. I don't know if this is possible, since, as I stated before, the Find duplicates option is disabled at my 97 Access.
Thank you in advance!!
Best regards
To answer that question, that answer is No, not out of the box. Not to say that you couldn't develop something that would say that. You could simply do a character by character compare and see how many of them match, and if the total is above a certain amount, you can simply display that record.
If you would like code examples, let me know. It would take a day to develop, but would be will to assist you in that.
Joe P.
Bender, first and foremost, thank you very much for your help!
I don't have much idea of SQL language, but this code looks like the one behind a Totals query. Am I right? Anyway, does this code enable Access to discriminate between, say, two Customer Names that, being in fact the same, differ from, say, a single or a couple of characters/numbers? I suspect that with this SQL code, this case would not be detected.
My question is, does the Find duplicates query/wizard discriminate between two records that are very similar, that is, does Access gives you a tip like: "hey, this two records have a 95% or more of similarity. Could they be a duplicate entry?"??. I don't know if this is possible, since, as I stated before, the Find duplicates option is disabled at my 97 Access.
Thank you in advance!!
Best regards
I agree with pianoman. You would have to develop a query to work in the manner that you specified. As for the SQL I provided, this was the SQL produced from a "Find Duplicate" query in a testing database I developed using the wizard. It simply states:
Show field1 and field2 where exact duplicates exist in field1. This example looks at the entire record for matches. Perhaps you could build on to it.
Bender
To answer that question, that answer is No, not out of the box. Not to say that you couldn't develop something that would say that. You could simply do a character by character compare and see how many of them match, and if the total is above a certain amount, you can simply display that record.
If you would like code examples, let me know. It would take a day to develop, but would be will to assist you in that.
Joe P.
Joe:
Thank you very much for your offering. Anyway, this is not a top priority for me right now and I would not want you to spend an entire day on this.
Indeed, thank you very much! I would like to offer some of my knowledge in return but I am afraid my Access knowledge does not go beyond the fundamentals that can be read in the common textbook (like Access The Bible, The Reference and stuff like that). In fact, I am stunned by the knowledge people in here possess!!!
Best regards from Barcelona
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: P |
last post by:
Hi,
How would one get a list of encodings
that can be passed to "".encode()
I know base64,utf8,latin,ascii work
and these are listed in the encodings
and codecs modules, but where can one
get a definitive list?
|
by: salem.ganzhorn |
last post by:
#include <map>
#include <iostream>
using namespace std;
int main(
int argc,
const char * argv
)
{
|
by: Praveen |
last post by:
In the ISPF editor I am using, for a particullar PO Dataset I am
getting the result of FIND statement narrowed down to the colums
48-56. i.e. if I give "FIND 'TO' ALL", the result I am getting as
"CHARS 'TO' - found 239 times within columns 48 to 56".
Please guide me as to how to make this PDS back to normal so that the
FIND command processes the whole 1 TO 80.
Thank you for the valuable time.
|
by: Phil |
last post by:
Hi.
There is probably a very simple explanation for this. I am using the
find duplicates wizard, I am asked for the fields that may contain
duplcate info. So far so good at this point it functions well and i
can see the records. If I reconsruct the query and put other records
that I want shown, the query shows no records at all.
I Have searched the web and this rescource and can not find a
reference to this prob.
|
by: Phil |
last post by:
Hi Daryl.
Thanks for you interest. I don't have the SQL, unlesss you mean the
SQL behind the query?
as to the "re-structuring" The first part of the wizard asks for the
fields that may contain duplicate info, then click next, the wizard
then asks you for fields that you wish to be shown within the query.
If I input the fields on the first part and imput nothing on the
second part the query shows duplicates, if I "reconstruct" or use the...
| |
by: Ori :) |
last post by:
I am writing an application to retrieve appointments from Outlook, I have the appointment items sorted by
"Start" field and now I want to find the first record which's "Start" value is later than now (future appointment
The relevant piece of my current code
Dim oCalendar As Outlook.MAPIFolder = oNS.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderCalendar
Dim oItems As Outlook.Items = oCalendar.Item
oItems.Sort("Start"...
|
by: Rave |
last post by:
This is a long shot, but I thought I'd try it. I am currently using excel as an inventory tool. I currently have a hand-held scanner plugged into a laptop for reading barcodes. Using the "Find and Replace" fuction, I scan the merchandise which then searches the spreadsheet for the matching inventory number. When it is found, I highlight that cell in yellow. After scanning and coloring all of my inventory I can then see exactly what is...
|
by: scripteaze |
last post by:
Im using mechanize method for retrieving the form so that i may log
into it. I need to find a way to get the form name. Its not listed
anywhere in the html source.The reason i need to do this is because im
tryin not to use the for loop below. Someone told me that the form
name should be listed in the 'print form' portion of the codes output.
I dont believe the form name is listed there also. Any ideas/help
would be great. Thank you in...
|
by: Ornitobase |
last post by:
Hello,
my form is used to filter data displayed in its subform. The origin of
the data of the subform is dynamically generated.
The filters work in VBA. The code is inspired by Allen Browne's
"Search2000":
http://allenbrowne.com/ser-62.html
Now, I'd like to have an option in the main form to hide the entries
in the subform that I consider duplicates (entries with same
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |