Query that returns values greater than zero

[Guest]

This seems simple, but I can't figure it out! I have a large database that
lists about 200 employees and 20 schools. The employees have worked for some,
but not all of the schools. Each employee indicated how many times they have
worked for a particular school - from zero on up. I want to have a query
that will show the employee name, and then only show the schools that they
have taught for...so any value greater than zero.

I tried using a criteria of 'If Not Null' and it still pulled in all of the
records...any suggestions on how to do a 'greater than zero' criteria?

I am using Access 2002 on a PC running XP.

Thanks!

 

[John Spencer]

Not Null means there is a value in the field - zero is a value.

Perhaps what you want is criteria of > 0 (greater than zero)

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

 

[Guest]

I tried using a criteria of 'If Not Null'
The proper syntax is Is Not NullYou really did not say what your structure was. Does the employee records
have a field for each school (spreadsheet fashion)? Or is there a record
per employee-school?