Access 2003 Select Query

[Guest]

I am a new user. How do I create this query:

OS is not XP and AssetModel is not a Dell. I have one table that I am
using.

 

[Douglas J. Steele]

The WHERE clause would be:

WHERE OS <> "XP" AND AssetModel <> "Dell"

To build that through the graphical query builder, you'd put

<> "XP"

as the criteria under the OS field, and

<> "Dell"

as the criteria under the AssetModel field.