by: Tom Mitchell |
last post by:
All:
I'm stumped on a query. How do I find duplicates in a table where one
of the duplicates has values is a certain field and the other doesn't.
For example, I have the following table:
...
|
by: Erik Schweitzer |
last post by:
I work for a tool & die shop, and we have an Access DB that captures
work performed on each job we do. Each job could have 5 or more
entries for work performed on it. I am trying to create a...
|
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...
|
by: Phil |
last post by:
Hi.
I have a table containing primary address, secondary address,
road,town, postcode, there are otherfields within the table requestid,
round, day, etc.
I want to find all instances of the...
|
by: Jerry |
last post by:
Say a table has four fields:
ID (PK)
Field1
Field2
Field3
Field 1 is indexed as Yes(No Duplicates)
When a duplicate is entered in Field1, nothing happens until you try to save
the record then...
|
by: Mong |
last post by:
Hi,
I've got an application that imports records from a text file into a
temporary table. I then want to insert from the temp table into a
master table but only records which are not in there...
|
by: Killer42 |
last post by:
Hi all.
Sorry, this is probably a really simple one but I'm having some difficulty with it, and don't have much time to devote to it right now.
I need to find all the records which have...
|
by: limperger |
last post by:
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...
|
by: iheartvba |
last post by:
To put the below code simply, I have created a find duplicates query for a table using the Access query wizard. I have then tried to plug the Sql String (strSqlDupColl) copied from the Query Builder...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
|
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...
|