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 relationships might be a
little crazy. Any help would be great. Thanks

Jason,
Try...
Not "Software" and Not "Office"
or
<> "Software" And <> "Office"
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Jason Marino" <jmarino@mahoneycohen.com> wrote in message
news:uKe8PBK%23IHA.1512@TK2MSFTNGP06.phx.gbl...
>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 relationships might be a little
> crazy. Any help would be great. Thanks

I suggest you repost your question in the Queries group and include the SQL
of the query so someone can evaluate your problem.
--
Dave Hargis, Microsoft Access MVP


"Jason Marino" wrote:

> 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 relationships might be a
> little crazy. Any help would be great. Thanks
>

For those without serial numbers you need to restrict the results to rows
where:

SerialNumber IS NULL

assuming that the column will be NULL, rather than a zero-length string or 0
of course.

To exclude anything which is not hardware you can use NOT IN(<value list>).

So in the first criteria row of the SerialNumber column enter:

IS NULL

and in the first 'criteria' row of the EquipmentType column enter:

NOT IN("Office", "Software")

Ken Sheridan
Stafford, England

"Jason Marino" wrote:

> 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 relationships might be a
> little crazy. Any help would be great. Thanks
>