How to run a query/sql command filtering out duplicate description and device names

[bb18mn]

Hi there,



I am currently building a database for our asset management at work and I have complied a database from our Active directory for all of our laptop/PC devices and users on our domain.

Under these PC/laptops we added descriptions to who is assigned to that specific PC. When I run a query it will give me that data but it pulls over 9.6 million entries which I think it is pulling login entries.

Do you know a sql command or query on pulling the username and Match it to the Description field in ALL_Computers table?

I am stumped if access will be able to do this. Thanks!

[pbaldy]

Well, a join on that field would work if the data is appropriate. Might help to see an example of the data in the different tables, and the result you expect.