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  947 
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
Now, was this 'knowledge creeping up on you', or was it Mary reprogramming your mind?
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: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
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...
| |
