Hi all.
Isn't it funny how knowledge sneaks up on you while you're not looking. :-)
I threw together a query in Access today, to return all the records which were duplicated in another table by concatenating some fields and using an In( ) function. Gave it a run, it worked, then I thought... "Hang on - I didn't know how to do that!"
Guess that's what I get from spending so much time browsing the Access forum. :D
4 949 MMcCarthy 14,534
Recognized Expert Moderator MVP
Hi all.
Isn't it funny how knowledge sneaks up on you while you're not looking. :-)
I threw together a query in Access today, to return all the records which were duplicated in another table by concatenating some fields and using an In( ) function. Gave it a run, it worked, then I thought... "Hang on - I didn't know how to do that!"
Guess that's what I get from spending so much time browsing the Access forum. :D
That's great Killer.
Mary
Ganon11 3,652
Recognized Expert Specialist
Now, was this 'knowledge creeping up on you', or was it Mary reprogramming your mind?
MMcCarthy 14,534
Recognized Expert Moderator MVP
Now, was this 'knowledge creeping up on you', or was it Mary reprogramming your mind?
Ssssh Ganon. Don't be telling all my secrets.
Now, was this 'knowledge creeping up on you', or was it Mary reprogramming your mind?
I'm much more comfortable thinking of it as the former, thanks very much.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Elaine Jackson |
last post by:
I want to run an http server but I don't know how to get started. I've read
through the documentation for the relevant modules, but I don't have enough http
knowledge to get the initial spark I...
|
by: Maurice LING |
last post by:
Hi,
I've learnt and used Java and Python for a few years now, on bits of my
thesis work etc etc. I will have to say that I love both languages and
the possibilities they can provide. More...
|
by: Mark Moeykens |
last post by:
Does anyone know of a place that has a collection of tips and tricks or
hard-won knowledge in regards to .NET.
You know what I'm talking about, that kind of knowledge where once you learn
it you...
|
by: Yasso Picasso |
last post by:
Greetings,
I have to admit that I'm still a beginner in the database field, but I'm
actively studying, and this is why I will be utterly grateful for the
proper, accurate, and wise guidance to...
|
by: Sushil Srivastava |
last post by:
Hi Guys,
I have developed a utility that provide a smart MSDN
knowledge base search both off-line and on-line. I have
describe more in detail below why I decided to write this
utility (one...
|
by: Sai Kit Tong |
last post by:
In the article, the description for
"Modiy DLL That Contains Consumers That Use Managed Code and DLL Exports
or
Managed Entry Points"
suggests the creation of the class ManagedWrapper.
If I...
|
by: nano2k |
last post by:
Hi
It's maybe offtopic, but do you guys have an ideea of how to develop
an knowledge base for troubleshooting an application?
Picture this. After deploying an application to multiple locations,...
|
by: NAU programmers |
last post by:
Hey folks,
Me and my friend are beginning our 3rd year at Computer engineering
faculty in a university in Kiev-Ukraine . Unfortunately, there aren't
any good professors in our university, and the...
|
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: 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: 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...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
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 ...
| |