Help on a query

  • Thread starter Thread starter Nogger-01
  • Start date Start date
N

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
 
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
 
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
 
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
 
Back
Top