I am trying to make a query with multiple criteria in it. Every time i
add the second criteria to the line it dosent filter out that criteria.
For example i need to create a query that tells me everybody in an
office with equipment that dosent have a serial number, but i need to
filter out any software or anything that is not hardware.
So i create the query and i s Not "software" and "Office". When i run
the query it does not filter out software or office. How do i fix this.
Keep in mind i did not build the db so the relation****ps might be a
little crazy. Any help would be great. Thanks
