By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,471 Members | 2,264 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,471 IT Pros & Developers. It's quick & easy.

A few routine programs

P: n/a
I am looking for a few handy routines. Please advise websites that may have
these programs available. Thanks.

1. A routine to check duplicate entries in a query/table and put these
duplicates in a separate query/table.

2. A routine to run compare of two queries/tables and put the unmatched in
separate tables/queries. i.e. entries in A table but not in B table;
entries not in A table but in B table.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Sherman H. wrote:
I am looking for a few handy routines. Please advise websites that may have
these programs available. Thanks.

1. A routine to check duplicate entries in a query/table and put these
duplicates in a separate query/table.
I think you can do it. Click on the query tab, select New, then
SimpleQueryWizard. This presents a wizard for you to follow. Once it
is created, open it in design mode and make it a MakeTable query.

2. A routine to run compare of two queries/tables and put the unmatched in
separate tables/queries. i.e. entries in A table but not in B table;
entries not in A table but in B table.

I think you can do it. Click on the query tab, select New, then
FindUnMatched. This presents a wizard for you to follow. Once it is
created, open it in design mode and make it a MakeTable query.
Nov 12 '05 #2

P: n/a
Sherman,

there are wizards in access to find duplicates and unmatched - just go Query
New and select from the last 2 options. cheers,
--

Bob Bykerk,
Principal Consultant
InformatIQ Pty Ltd
0419 44 77 03
(02) 93652520
"Sherman H." <sh***@charter.net> wrote in message
news:10*************@corp.supernews.com... I am looking for a few handy routines. Please advise websites that may have these programs available. Thanks.

1. A routine to check duplicate entries in a query/table and put these
duplicates in a separate query/table.

2. A routine to run compare of two queries/tables and put the unmatched in
separate tables/queries. i.e. entries in A table but not in B table;
entries not in A table but in B table.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.