|
 |
access thread: Only display duplicates
Message #1 by "James" <j.boorman@u...> on Tue, 27 Aug 2002 16:54:13
|
|
Ok dumb question, but how do you display on records that have a duplicate
value.
I am interested in searching my data with a query I have, but would like
to narrow the criteria further to only show records that match the
criteria and have duplicate aplhanumeric values in a field.
Have tried the COUNT command, but it does not recognise duplicate
aplhanumeric values.
Cheers
James
Message #2 by "Carnley, Dave" <dcarnley@a...> on Tue, 27 Aug 2002 11:09:23 -0500
|
|
need more detail about table structures, where dupes can happen...
-----Original Message-----
From: James [mailto:j.boorman@u...]
Sent: Tuesday, August 27, 2002 11:54 AM
To: Access
Subject: [access] Only display duplicates
Ok dumb question, but how do you display on records that have a duplicate
value.
I am interested in searching my data with a query I have, but would like
to narrow the criteria further to only show records that match the
criteria and have duplicate aplhanumeric values in a field.
Have tried the COUNT command, but it does not recognise duplicate
aplhanumeric values.
Cheers
James
Message #3 by "Yehuda Rosenblum" <Yehuda@I...> on Tue, 27 Aug 2002 12:11:24 -0400
|
|
Use the DISTINCT command (select DISTINCT etc.)
-----Original Message-----
From: James [mailto:j.boorman@u...]
Sent: Tuesday, August 27, 2002 12:54 PM
To: Access
Subject: [access] Only display duplicates
Ok dumb question, but how do you display on records that have a
duplicate
value.
I am interested in searching my data with a query I have, but would like
to narrow the criteria further to only show records that match the
criteria and have duplicate aplhanumeric values in a field.
Have tried the COUNT command, but it does not recognise duplicate
aplhanumeric values.
Cheers
James
Message #4 by "Carnley, Dave" <dcarnley@a...> on Tue, 27 Aug 2002 11:19:56 -0500
|
|
the DISTINCT command will ELIMINATE duplicates.
-----Original Message-----
From: Yehuda Rosenblum [mailto:Yehuda@I...]
Sent: Tuesday, August 27, 2002 11:11 AM
To: Access
Subject: [access] RE: Only display duplicates
Use the DISTINCT command (select DISTINCT etc.)
-----Original Message-----
From: James [mailto:j.boorman@u...]
Sent: Tuesday, August 27, 2002 12:54 PM
To: Access
Subject: [access] Only display duplicates
Ok dumb question, but how do you display on records that have a
duplicate
value.
I am interested in searching my data with a query I have, but would like
to narrow the criteria further to only show records that match the
criteria and have duplicate aplhanumeric values in a field.
Have tried the COUNT command, but it does not recognise duplicate
aplhanumeric values.
Cheers
James
Message #5 by Beth Moffitt <BethMoffitt@i...> on Tue, 27 Aug 2002 11:24:47 -0500
|
|
Group the alphanumeric field and Count the primary Key with the criteria of
>1.
Beth Moffitt
Developer
INI, Inc.
xxx.xxx.xxxx x110
www.iniinc.com
-----Original Message-----
From: James [mailto:j.boorman@u...]
Sent: Tuesday, August 27, 2002 11:54 AM
To: Access
Subject: [access] Only display duplicates
Ok dumb question, but how do you display on records that have a duplicate
value.
I am interested in searching my data with a query I have, but would like
to narrow the criteria further to only show records that match the
criteria and have duplicate aplhanumeric values in a field.
Have tried the COUNT command, but it does not recognise duplicate
aplhanumeric values.
Cheers
James
Message #6 by "James" <j.boorman@u...> on Tue, 27 Aug 2002 17:42:58
|
|
Hi Dave,
Table structure is as follows:
Table: all_data
5 fields
[ExperimentID] [ExpressionID][Expression] [Fold change] [Accession]
Only the fold change field is a numeric field, the others are text.
Duplicates can occur in the [Accession] field.
I have a query that returns the results of a search of the data where the
Fold change value is above a certain threshold and the expression field
equals a certain value that the user inputs.
Now the thing is that the data represents many experiments and I am mostly
interested in experiments that conform to the criteria described in the
query, but also have the same value in the Accession field.
So what I want to do is ONLY display all records that conform to my
inputted criteria and also share the same Accession value.
Current Query:
SELECT all_data.Experiment, all_data.Expressionid, all_data.expression,
all_data.[Fold change], all_data.Accession
FROM all_data
WHERE IIf([Increase or decrease]="i",[expression] And [Fold change]>
[Foldchange_Greater than],[expression]="d" And [Fold change]<"-" &
[Foldchange_Greater than]) Or IIf([Foldchange_Greater than] Is Null,
[expression]=[Increase or decrease])
ORDER BY [Accession];
Thanks
James
> need more detail about table structures, where dupes can happen...
-----Original Message-----
From: James [mailto:j.boorman@u...]
Sent: Tuesday, August 27, 2002 11:54 AM
To: Access
Subject: [access] Only display duplicates
Ok dumb question, but how do you display on records that have a duplicate
value.
I am interested in searching my data with a query I have, but would like
to narrow the criteria further to only show records that match the
criteria and have duplicate aplhanumeric values in a field.
Have tried the COUNT command, but it does not recognise duplicate
aplhanumeric values.
Cheers
James
Message #7 by "James" <j.boorman@u...> on Tue, 27 Aug 2002 17:45:10
|
|
Thanks Beth,
Tried this and it tells me how many duplicates I have, but does not show
me which records have the duplicates.
James
> Group the alphanumeric field and Count the primary Key with the criteria
of
>1.
Beth Moffitt
Developer
INI, Inc.
xxx.xxx.xxxx x110
www.iniinc.com
-----Original Message-----
From: James [mailto:j.boorman@u...]
Sent: Tuesday, August 27, 2002 11:54 AM
To: Access
Subject: [access] Only display duplicates
Ok dumb question, but how do you display on records that have a duplicate
value.
I am interested in searching my data with a query I have, but would like
to narrow the criteria further to only show records that match the
criteria and have duplicate aplhanumeric values in a field.
Have tried the COUNT command, but it does not recognise duplicate
aplhanumeric values.
Cheers
James
Message #8 by "Carnley, Dave" <dcarnley@a...> on Tue, 27 Aug 2002 12:07:26 -0500
|
|
try this
in access create a query base don the one you gave below. Lets call it Q1
now create a new query Q2 like this
select q1.Accession, count(*)
from q1
group by q1.Accession
having count(*) > 1
now create query Q3
select * from Q1
where q1.Accession = q2.Accession
there are probably more elegant ways to do it...
-----Original Message-----
From: James [mailto:j.boorman@u...]
Sent: Tuesday, August 27, 2002 12:43 PM
To: Access
Subject: [access] RE: Only display duplicates
Hi Dave,
Table structure is as follows:
Table: all_data
5 fields
[ExperimentID] [ExpressionID][Expression] [Fold change] [Accession]
Only the fold change field is a numeric field, the others are text.
Duplicates can occur in the [Accession] field.
I have a query that returns the results of a search of the data where the
Fold change value is above a certain threshold and the expression field
equals a certain value that the user inputs.
Now the thing is that the data represents many experiments and I am mostly
interested in experiments that conform to the criteria described in the
query, but also have the same value in the Accession field.
So what I want to do is ONLY display all records that conform to my
inputted criteria and also share the same Accession value.
Current Query:
SELECT all_data.Experiment, all_data.Expressionid, all_data.expression,
all_data.[Fold change], all_data.Accession
FROM all_data
WHERE IIf([Increase or decrease]="i",[expression] And [Fold change]>
[Foldchange_Greater than],[expression]="d" And [Fold change]<"-" &
[Foldchange_Greater than]) Or IIf([Foldchange_Greater than] Is Null,
[expression]=[Increase or decrease])
ORDER BY [Accession];
Thanks
James
> need more detail about table structures, where dupes can happen...
-----Original Message-----
From: James [mailto:j.boorman@u...]
Sent: Tuesday, August 27, 2002 11:54 AM
To: Access
Subject: [access] Only display duplicates
Ok dumb question, but how do you display on records that have a duplicate
value.
I am interested in searching my data with a query I have, but would like
to narrow the criteria further to only show records that match the
criteria and have duplicate aplhanumeric values in a field.
Have tried the COUNT command, but it does not recognise duplicate
aplhanumeric values.
Cheers
James
Message #9 by "Gerald, Rand" <RGerald@u...> on Tue, 27 Aug 2002 12:08:51 -0500
|
|
This sample was built using the Queries / New / Find Duplicates Query
Wizard
in Access 2K.
SELECT tblPeople.FirstName, tblPeople.LastName, tblPeople.PeopleID,
tblPeople.RegistrationID
FROM tblPeople
WHERE (((tblPeople.FirstName) In (SELECT [FirstName] FROM [tblPeople]
As Tmp
GROUP BY [FirstName],[LastName] HAVING Count(*)>1 And [LastName] =3D
[tblPeople].[LastName])))
ORDER BY tblPeople.FirstName, tblPeople.LastName;
Try the wizard it may help you.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: James [mailto:j.boorman@u...]
Sent: Tuesday, August 27, 2002 12:45 PM
To: Access
Subject: [access] RE: Only display duplicates
Thanks Beth,
Tried this and it tells me how many duplicates I have, but does not
show
me which records have the duplicates.
James
> Group the alphanumeric field and Count the primary Key with the
criteria
of
>1.
Beth Moffitt
Developer
INI, Inc.
xxx.xxx.xxxx x110
www.iniinc.com
-----Original Message-----
From: James [mailto:j.boorman@u...]
Sent: Tuesday, August 27, 2002 11:54 AM
To: Access
Subject: [access] Only display duplicates
Ok dumb question, but how do you display on records that have a
duplicate
value.
I am interested in searching my data with a query I have, but would
like
to narrow the criteria further to only show records that match the
criteria and have duplicate aplhanumeric values in a field.
Have tried the COUNT command, but it does not recognise duplicate
aplhanumeric values.
Cheers
James
Message #10 by Beth Moffitt <BethMoffitt@i...> on Tue, 27 Aug 2002 13:01:20 -0500
|
|
Then you create another query based on the table and the first query where
the alphanumeric field is joined. This will return all record rows which
have the duplicate values.
Beth
-----Original Message-----
From: James [mailto:j.boorman@u...]
Sent: Tuesday, August 27, 2002 12:45 PM
To: Access
Subject: [access] RE: Only display duplicates
Thanks Beth,
Tried this and it tells me how many duplicates I have, but does not show
me which records have the duplicates.
James
> Group the alphanumeric field and Count the primary Key with the criteria
of
>1.
Beth Moffitt
Developer
INI, Inc.
xxx.xxx.xxxx x110
www.iniinc.com
-----Original Message-----
From: James [mailto:j.boorman@u...]
Sent: Tuesday, August 27, 2002 11:54 AM
To: Access
Subject: [access] Only display duplicates
Ok dumb question, but how do you display on records that have a duplicate
value.
I am interested in searching my data with a query I have, but would like
to narrow the criteria further to only show records that match the
criteria and have duplicate aplhanumeric values in a field.
Have tried the COUNT command, but it does not recognise duplicate
aplhanumeric values.
Cheers
James
Message #11 by "Leo Scott" <leoscott@c...> on Tue, 27 Aug 2002 11:25:17 -0700
|
|
Why not just use the built-in Access Find Duplicates query wizard. From the
query window click New then in the dialog box select Find Duplicates Query
Wizard. It will allow you to pick 1 to 10 fields to require a match on and
then allow you to put the rest of the fields in the returned recordset.
This should give you what you want.
|-----Original Message-----
|From: James [mailto:j.boorman@u...]
|Sent: Tuesday, August 27, 2002 4:54 PM
|To: Access
|Subject: [access] Only display duplicates
|
|
|Ok dumb question, but how do you display on records that have a duplicate
|value.
|
|I am interested in searching my data with a query I have, but would like
|to narrow the criteria further to only show records that match the
|criteria and have duplicate aplhanumeric values in a field.
|
|Have tried the COUNT command, but it does not recognise duplicate
|aplhanumeric values.
|
|Cheers
|
|James
|
Message #12 by "Carnley, Dave" <dcarnley@a...> on Tue, 27 Aug 2002 14:40:44 -0500
|
|
wizards are for wimps LOL!
$8^D
-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Tuesday, August 27, 2002 1:25 PM
To: Access
Subject: [access] RE: Only display duplicates
Why not just use the built-in Access Find Duplicates query wizard. From the
query window click New then in the dialog box select Find Duplicates Query
Wizard. It will allow you to pick 1 to 10 fields to require a match on and
then allow you to put the rest of the fields in the returned recordset.
This should give you what you want.
|-----Original Message-----
|From: James [mailto:j.boorman@u...]
|Sent: Tuesday, August 27, 2002 4:54 PM
|To: Access
|Subject: [access] Only display duplicates
|
|
|Ok dumb question, but how do you display on records that have a duplicate
|value.
|
|I am interested in searching my data with a query I have, but would like
|to narrow the criteria further to only show records that match the
|criteria and have duplicate aplhanumeric values in a field.
|
|Have tried the COUNT command, but it does not recognise duplicate
|aplhanumeric values.
|
|Cheers
|
|James
|
Message #13 by "Leo Scott" <leoscott@c...> on Tue, 27 Aug 2002 13:00:54 -0700
|
|
Then you must hand code everything in C++ since VB/VBA is one major wizard.
Do you ever get enough product out to get paid this way? Grin.
|-----Original Message-----
|From: Carnley, Dave [mailto:dcarnley@a...]
|Sent: Tuesday, August 27, 2002 12:41 PM
|To: Access
|Subject: [access] RE: Only display duplicates
|
|
|wizards are for wimps LOL!
|
|$8^D
|
|
|
|
|-----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Tuesday, August 27, 2002 1:25 PM
|To: Access
|Subject: [access] RE: Only display duplicates
|
|
|Why not just use the built-in Access Find Duplicates query wizard.
| From the
|query window click New then in the dialog box select Find Duplicates Query
|Wizard. It will allow you to pick 1 to 10 fields to require a match on and
|then allow you to put the rest of the fields in the returned recordset.
|This should give you what you want.
|
||-----Original Message-----
||From: James [mailto:j.boorman@u...]
||Sent: Tuesday, August 27, 2002 4:54 PM
||To: Access
||Subject: [access] Only display duplicates
||
||
||Ok dumb question, but how do you display on records that have a duplicate
||value.
||
||I am interested in searching my data with a query I have, but would like
||to narrow the criteria further to only show records that match the
||criteria and have duplicate aplhanumeric values in a field.
||
||Have tried the COUNT command, but it does not recognise duplicate
||aplhanumeric values.
||
||Cheers
||
||James
||
|
|
|
Message #14 by "Gerald, Rand" <RGerald@u...> on Tue, 27 Aug 2002 15:57:17 -0500
|
|
If you look at my earlier example, you will see that the wizard built a
nested SQL query to get the job done in less than one minute of my
time.
I look at wizards as timesavers. I guess that you NON-WIMPS have
nothing to
do in your copious spare time.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Carnley, Dave [mailto:dcarnley@a...]
Sent: Tuesday, August 27, 2002 2:41 PM
To: Access
Subject: [access] RE: Only display duplicates
wizards are for wimps LOL!
$8^D
-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Tuesday, August 27, 2002 1:25 PM
To: Access
Subject: [access] RE: Only display duplicates
Why not just use the built-in Access Find Duplicates query wizard.
From the
query window click New then in the dialog box select Find Duplicates
Query
Wizard. It will allow you to pick 1 to 10 fields to require a match on
and
then allow you to put the rest of the fields in the returned recordset.
This should give you what you want.
|-----Original Message-----
|From: James [mailto:j.boorman@u...]
|Sent: Tuesday, August 27, 2002 4:54 PM
|To: Access
|Subject: [access] Only display duplicates
|
|
|Ok dumb question, but how do you display on records that have a
duplicate
|value.
|
|I am interested in searching my data with a query I have, but would
like
|to narrow the criteria further to only show records that match the
|criteria and have duplicate aplhanumeric values in a field.
|
|Have tried the COUNT command, but it does not recognise duplicate
|aplhanumeric values.
|
|Cheers
|
|James
|
Message #15 by "Leo Scott" <leoscott@c...> on Tue, 27 Aug 2002 14:06:09 -0700
|
|
Hey, sometimes we just have to lighten-up. ;-)
|-----Original Message-----
|From: Gerald, Rand [mailto:RGerald@u...]
|Sent: Tuesday, August 27, 2002 1:57 PM
|To: Access
|Subject: [access] RE: Only display duplicates
|
|
|If you look at my earlier example, you will see that the wizard built a
|nested SQL query to get the job done in less than one minute of my time.
|
|I look at wizards as timesavers. I guess that you NON-WIMPS have
|nothing to
|do in your copious spare time.
|
|Rand E Gerald
|Database Specialist
|Information Services / Operations
|Bahá'í National Office
|1233 Central St.
|Evanston IL 60201
|(xxx) xxx-xxxx
|
|-----Original Message-----
|From: Carnley, Dave [mailto:dcarnley@a...]
|Sent: Tuesday, August 27, 2002 2:41 PM
|To: Access
|Subject: [access] RE: Only display duplicates
|
|wizards are for wimps LOL!
|
|$8^D
|
|
|
|
|-----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Tuesday, August 27, 2002 1:25 PM
|To: Access
|Subject: [access] RE: Only display duplicates
|
|
|Why not just use the built-in Access Find Duplicates query wizard.
| From the
|query window click New then in the dialog box select Find Duplicates Query
|Wizard. It will allow you to pick 1 to 10 fields to require a match on and
|then allow you to put the rest of the fields in the returned recordset.
|This should give you what you want.
|
||-----Original Message-----
||From: James [mailto:j.boorman@u...]
||Sent: Tuesday, August 27, 2002 4:54 PM
||To: Access
||Subject: [access] Only display duplicates
||
||
||Ok dumb question, but how do you display on records that have a duplicate
||value.
||
||I am interested in searching my data with a query I have, but would like
||to narrow the criteria further to only show records that match the
||criteria and have duplicate aplhanumeric values in a field.
||
||Have tried the COUNT command, but it does not recognise duplicate
||aplhanumeric values.
||
||Cheers
||
||James
||
|
|
|
|
Message #16 by "Carnley, Dave" <dcarnley@a...> on Tue, 27 Aug 2002 16:32:02 -0500
|
|
I frequently re-write the Access object library to suit my needs. For
example I wanted a drop down list that went up not down so I re-wrote
the
COMCTL.DLL one afternoon. it's easy. one time we needed the vertical
scroll bars to run horizontal and the horizontal ones to run vertical
(don't
ask!!!). I had to re-code most of Win/ME for that one! Just yesterday
I
hacked Oracle to accept "SLEECT ... FORM" because I was tired of
spelling it
correctly. Its just a matter of priorities...
http://www-csli.stanford.edu/%7Ejohn/procrastination.html
-----Original Message-----
From: Gerald, Rand [mailto:RGerald@u...]
Sent: Tuesday, August 27, 2002 3:57 PM
To: Access
Subject: [access] RE: Only display duplicates
If you look at my earlier example, you will see that the wizard built a
nested SQL query to get the job done in less than one minute of my
time.
I look at wizards as timesavers. I guess that you NON-WIMPS have
nothing to
do in your copious spare time.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Carnley, Dave [mailto:dcarnley@a...]
Sent: Tuesday, August 27, 2002 2:41 PM
To: Access
Subject: [access] RE: Only display duplicates
wizards are for wimps LOL!
$8^D
-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Tuesday, August 27, 2002 1:25 PM
To: Access
Subject: [access] RE: Only display duplicates
Why not just use the built-in Access Find Duplicates query wizard.
From the
query window click New then in the dialog box select Find Duplicates
Query
Wizard. It will allow you to pick 1 to 10 fields to require a match on
and
then allow you to put the rest of the fields in the returned recordset.
This should give you what you want.
|-----Original Message-----
|From: James [mailto:j.boorman@u...]
|Sent: Tuesday, August 27, 2002 4:54 PM
|To: Access
|Subject: [access] Only display duplicates
|
|
|Ok dumb question, but how do you display on records that have a
duplicate
|value.
|
|I am interested in searching my data with a query I have, but would
like
|to narrow the criteria further to only show records that match the
|criteria and have duplicate aplhanumeric values in a field.
|
|Have tried the COUNT command, but it does not recognise duplicate
|aplhanumeric values.
|
|Cheers
|
|James
|
Message #17 by John Fejsa <John.Fejsa@h...> on Wed, 28 Aug 2002 08:46:08 +1000
|
|
And the rest keep on reinventing the wheel. If it works, use it. Trying to prove that professionals
don't need to use a quick wizard now and then is definitely unprofessional*
____________________________________________________
John Fejsa
Systems Analyst/Computer Programmer
Hunter Centre for Health Advancement
Locked Bag 10, WALLSEND NSW 2287
Phone: (02) 4924 6336 Fax: (02) 4924 6209
www.hcha.org.au
____________________________________________________
The doors we open and close each day decide the lives we live
____________________________________________________
CONFIDENTIALITY & PRIVILEGE NOTICE
The information contained in this email message is intended for the named addressee only. If you are not the intended recipient you
must not copy, distribute, take any action reliant on, or disclose any details of the information in this email to any other person
or organisation. If you have received this email in error please notify us immediately.
>>> dcarnley@a... 28/08/2002 5:40:44 >>>
wizards are for wimps LOL!
$8^D
-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Tuesday, August 27, 2002 1:25 PM
To: Access
Subject: [access] RE: Only display duplicates
Why not just use the built-in Access Find Duplicates query wizard. From the
query window click New then in the dialog box select Find Duplicates Query
Wizard. It will allow you to pick 1 to 10 fields to require a match on and
then allow you to put the rest of the fields in the returned recordset.
This should give you what you want.
|-----Original Message-----
|From: James [mailto:j.boorman@u...]
|Sent: Tuesday, August 27, 2002 4:54 PM
|To: Access
|Subject: [access] Only display duplicates
|
|
|Ok dumb question, but how do you display on records that have a duplicate
|value.
|
|I am interested in searching my data with a query I have, but would like
|to narrow the criteria further to only show records that match the
|criteria and have duplicate aplhanumeric values in a field.
|
|Have tried the COUNT command, but it does not recognise duplicate
|aplhanumeric values.
|
|Cheers
|
|James
|
Message #18 by "Leo Scott" <leoscott@c...> on Tue, 27 Aug 2002 16:51:44 -0700
|
|
You are truely amazing!
|-----Original Message-----
|From: Carnley, Dave [mailto:dcarnley@a...]
|Sent: Tuesday, August 27, 2002 2:32 PM
|To: Access
|Subject: [access] RE: Only display duplicates
|
|
|I frequently re-write the Access object library to suit my needs. For
|example I wanted a drop down list that went up not down so I re-wrote the
|COMCTL.DLL one afternoon. it's easy. one time we needed the vertical
|scroll bars to run horizontal and the horizontal ones to run
|vertical (don't
|ask!!!). I had to re-code most of Win/ME for that one! Just yesterday I
|hacked Oracle to accept "SLEECT ... FORM" because I was tired of
|spelling it
|correctly. Its just a matter of priorities...
|
|http://www-csli.stanford.edu/%7Ejohn/procrastination.html
|
|
|
|
|
|-----Original Message-----
|From: Gerald, Rand [mailto:RGerald@u...]
|Sent: Tuesday, August 27, 2002 3:57 PM
|To: Access
|Subject: [access] RE: Only display duplicates
|
|
|If you look at my earlier example, you will see that the wizard built a
|nested SQL query to get the job done in less than one minute of my time.
|
|I look at wizards as timesavers. I guess that you NON-WIMPS have
|nothing to
|do in your copious spare time.
|
|Rand E Gerald
|Database Specialist
|Information Services / Operations
|Bahá'í National Office
|1233 Central St.
|Evanston IL 60201
|(xxx) xxx-xxxx
|
|-----Original Message-----
|From: Carnley, Dave [mailto:dcarnley@a...]
|Sent: Tuesday, August 27, 2002 2:41 PM
|To: Access
|Subject: [access] RE: Only display duplicates
|
|wizards are for wimps LOL!
|
|$8^D
|
|
|
|
|-----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Tuesday, August 27, 2002 1:25 PM
|To: Access
|Subject: [access] RE: Only display duplicates
|
|
|Why not just use the built-in Access Find Duplicates query wizard.
| From the
|query window click New then in the dialog box select Find Duplicates Query
|Wizard. It will allow you to pick 1 to 10 fields to require a match on and
|then allow you to put the rest of the fields in the returned recordset.
|This should give you what you want.
|
||-----Original Message-----
||From: James [mailto:j.boorman@u...]
||Sent: Tuesday, August 27, 2002 4:54 PM
||To: Access
||Subject: [access] Only display duplicates
||
||
||Ok dumb question, but how do you display on records that have a duplicate
||value.
||
||I am interested in searching my data with a query I have, but would like
||to narrow the criteria further to only show records that match the
||criteria and have duplicate aplhanumeric values in a field.
||
||Have tried the COUNT command, but it does not recognise duplicate
||aplhanumeric values.
||
||Cheers
||
||James
||
|
|
|
|
|
|
Message #19 by "Carnley, Dave" <dcarnley@a...> on Wed, 28 Aug 2002 09:20:49 -0500
|
|
yeah if only my boss thought so. she keeps insisting that I actually
finish
projects that contribute to the bottom line. I don't know what her
problem
is.
ROFL!
-----Original Message-----
From: Leo Scott [mailto:leoscott@c...]
Sent: Tuesday, August 27, 2002 6:52 PM
To: Access
Subject: [access] RE: Only display duplicates
You are truely amazing!
|-----Original Message-----
|From: Carnley, Dave [mailto:dcarnley@a...]
|Sent: Tuesday, August 27, 2002 2:32 PM
|To: Access
|Subject: [access] RE: Only display duplicates
|
|
|I frequently re-write the Access object library to suit my needs. For
|example I wanted a drop down list that went up not down so I re-wrote
the
|COMCTL.DLL one afternoon. it's easy. one time we needed the vertical
|scroll bars to run horizontal and the horizontal ones to run
|vertical (don't
|ask!!!). I had to re-code most of Win/ME for that one! Just
yesterday I
|hacked Oracle to accept "SLEECT ... FORM" because I was tired of
|spelling it
|correctly. Its just a matter of priorities...
|
|http://www-csli.stanford.edu/%7Ejohn/procrastination.html
|
|
|
|
|
|-----Original Message-----
|From: Gerald, Rand [mailto:RGerald@u...]
|Sent: Tuesday, August 27, 2002 3:57 PM
|To: Access
|Subject: [access] RE: Only display duplicates
|
|
|If you look at my earlier example, you will see that the wizard built
a
|nested SQL query to get the job done in less than one minute of my
time.
|
|I look at wizards as timesavers. I guess that you NON-WIMPS have
|nothing to
|do in your copious spare time.
|
|Rand E Gerald
|Database Specialist
|Information Services / Operations
|Bah=E1'=ED National Office
|1233 Central St.
|Evanston IL 60201
|(xxx) xxx-xxxx
|
|-----Original Message-----
|From: Carnley, Dave [mailto:dcarnley@a...]
|Sent: Tuesday, August 27, 2002 2:41 PM
|To: Access
|Subject: [access] RE: Only display duplicates
|
|wizards are for wimps LOL!
|
|$8^D
|
|
|
|
|-----Original Message-----
|From: Leo Scott [mailto:leoscott@c...]
|Sent: Tuesday, August 27, 2002 1:25 PM
|To: Access
|Subject: [access] RE: Only display duplicates
|
|
|Why not just use the built-in Access Find Duplicates query wizard.
| From the
|query window click New then in the dialog box select Find Duplicates
Query
|Wizard. It will allow you to pick 1 to 10 fields to require a match
on and
|then allow you to put the rest of the fields in the returned
recordset.
|This should give you what you want.
|
||-----Original Message-----
||From: James [mailto:j.boorman@u...]
||Sent: Tuesday, August 27, 2002 4:54 PM
||To: Access
||Subject: [access] Only display duplicates
||
||
||Ok dumb question, but how do you display on records that have a
duplicate
||value.
||
||I am interested in searching my data with a query I have, but would
like
||to narrow the criteria further to only show records that match the
||criteria and have duplicate aplhanumeric values in a field.
||
||Have tried the COUNT command, but it does not recognise duplicate
||aplhanumeric values.
||
||Cheers
||
||James
||
|
|
|
|
|
|
|
|
|
View Cart
