Queries

[alicia]

This is probably really simple but I want to create a
query looking up everyones order ID numbers that are not
12. I know how to look up ID no's that are 12, but wat
about those that are not?
thanx

 

[chas]

Hi Alicia,

try using:

<>12

in the criteria for the field in question

hth

chas

 

[Stacy Ouellette]

In your query design enter the following in the criteria
section of the field.

Not 12

This will pull what you are looking for.

Stacy