Pulling data from table without duplicates 1

[Scrofani]

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.

 

[ZmrAbdulla]

You may get a better idea from thread701-1013971
Regards

Zameer Abdulla
[sub]Jack of Visual Basic Programming, Master in Dining & Sleeping[/sub]
Visit Me

 

[Scrofani]

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!).

 

[1oldfoxman]

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.