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

Question on duplicates

P: n/a
I'm new to access and I'm in the process of setting up a small
database for myself. I'm importing a list of document id's into a
database table. If I try to index and say "NO" to duplicates, I get a
message stating that I have duplicates. Does anyone know how to setup
access to kick the duplicates out to a list or something for me? I
have many documents ids and don't want to go thru each one.

Thanks !
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
aa********@msn.com wrote:
I'm new to access and I'm in the process of setting up a small
database for myself. I'm importing a list of document id's into a
database table. If I try to index and say "NO" to duplicates, I get a
message stating that I have duplicates. Does anyone know how to setup
access to kick the duplicates out to a list or something for me? I
have many documents ids and don't want to go thru each one.

Thanks !


You can put the IDs in a temporary table, and from there do an insert
query into the 'real' table; in that query you can use the DISTINCT
predicate to get every ID only once.

--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.