Probably a very easy question

[Ext1jdh]

Hi all,


I'm not very well versed in Access but I've used it for a while. I can work my way through it but I'm not completely proficient.

I've put together an inventory database with a table containing my data. It's simple but it works (so far). I need to put together a query that will return only the people with more than one desktop computer.

Here's the basics of what I'm working with:

FullName           HWType           Serial
user1              desktop          12345
user1              monitor          54321
user2              desktop          98765
user2              monitor          95184
user2              desktop          46521
user2              monitor          79582

Basically, I'd like the query to return:

user2              Desktop         98765
user2              Desktop         46521

Since almost all my records have more than one identical entry for FullName, and there are lots of HWType entries set to Desktop, I'm just a bit confused on how to do this. Like I said, This is probably something extremely simple.

Thanks in advance

[alansidman]

Using the Query Wizard, create a duplicates query and set the fields for duplicates to be the FullName and HWType. After running it, edit the HWType field to add to the criteria "Desktop"

Alan

[Ext1jdh]

In Access03, how do I create a duplicates query? In the wizard it just creates a standard query

[boblarson]

Here's a sample of one way to do it (there are other ways).

[Ext1jdh]

Sorry, problems with my Access installation and some issues at the office are preventing me from trying these out. I'll have to try when I'm able. Thanks for your help though.