Help on a query

[Nogger-01]

I am trying to creat a query that will check my data and bring back the lines
that have wrong data.

Eg.

i need the query to bring back were in the data there is a even number and a
sparate query to show a odd.

Thanks

 

[Klatuu]

In the WHERE clause of the query to get even numbers:

WHERE FieldToCheck Mod 2 = 0

To get odd numbers
WHERE FieldToCheck Mod 2 <> 0

 

[Nogger-01]

So on the query in the drop down box do i change that to were in sted of
group by ?

then what do i type in the Criteria field?

thanks

 

[Klatuu]

If you are going to have one query for even numbers and one for odd, it would
be WHERE.

 

[John Spencer]

For EVEN NUMBERS

FIeld: FieldToCheck MOD 2
Total: WHERE
Criteria: 0

For ODD NUMBERS
FIeld: FieldToCheck MOD 2
Total: WHERE
Criteria: 1

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County