×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Pulling data from table without duplicates

Pulling data from table without duplicates

Pulling data from table without duplicates

(OP)
I am a beginner regarding Access that works as a financial analyst and don't have experience with programming Visual Basic.  In 1993, I built my first and only Access database that I am proud to say was used by that company until 2004. Now, I am trying to build a very basic database and already ran into a problem.

I import a datasheet into my spreadsheet from excel that contains individual investments from a group of portfolios.  For example:

ACCT   HOLDING  SHARES...
1234   MSFT     1000
1234   DELL     500
1234   HP       700
9876   PG       2000
5555   XMSR     200
5555   SPX      500

I want to create a query that looks at this list and pulls out a list of all the accounts without duplicates.  Like this:

ACCT
1234
9876
5555

Not this:
1234
1234
1234
9876
5555
5555

How do I do this?  Thanks for the help.

RE: Pulling data from table without duplicates

You may get a better idea from Thread701-1013971
Regards

Zameer Abdulla
Jack of Visual Basic Programming, Master in Dining & Sleeping
Visit Me

RE: Pulling data from table without duplicates

(OP)
Thanks ZmrAbdulla.  It gave me the answer in a round-a-bout way.  In the thread you posted, there was a response mentioning a Find Duplicate Wizard.  So I opened up Microsoft Access Help to find the wizard, put in "duplicate" as the keyword, and "Delete duplicate records from a table" popped up as an option.  The instructions under this topic helped me do exactly what I needed.  

Thanks for the quick response (under 5 minutes!).

RE: Pulling data from table without duplicates

Sounds like you got what you needed already. The SQL query would be:

SELECT DISTINCT ACCT FROM MyTable

Where "MyTable" is the name of your Access database table.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close