A few routine programs

[Sherman H.]

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.

[Salad]

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.

[Bob Bykerk]

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
[phone]
"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.