Greetings!  I was trying to make a subject line more descriptive but I couldn't really summarize what I want to do in a single line.      Anyway, we have an inventory database with multiple tables but i'm concentrating on two specific ones.  One table is a list of Workstations, the other is a list of items that are within those workstations.  For example (very simplified):

 

Table Workstation

Fields:WSNUM, USERNAME, OS

-----------------------

1, User#1, Windows 7

2, User#2, Windows XP

3, User#3, Windows XP

4, User#4, Windows 7

-----------------------

 

 

 

Table Item

Fields: NAME, TYPE, WSNUM

-----------------------

Dell Optiplex, Computer, 1

MS Windows 7, License, 1

Dell Optiplex, Computer, 2

MS Windows XP, License 2

Dell Latitude, Computer, 3

MS Windows XP, License, 3

Dell Precision, Computer, 4

MS Windows 7, License, 4

-----------------------

 

 

I'm trying to figure out how to make a report which will only show Workstations which DON'T have a particular item, for this example, workstations which don't have "MS Windows 7" as an Item.  We are using Crystal XI and I can do is make a report which lists all items that don't match "MS Windows 7", but it shows all of the other items, even the ones on the same workstation.  I just want to list the Workstations which don't have that one paritcular item in it.  I've linked the two tables together using WSNUM as a common field.

 

Any thoughts?  Thanks!