Hi, I originally had one select query and one report for all our outstanding
issues (Status="Open").  We recently had to add a new enforcement category
(Obligations which happens to be 8 in the Enforcement Category table).  This
needs a seperate report so I simply copied both the report and the query and
altered them as below (one =8 and one <>8).  Both queries run and give me the
results I expect.  

However, the report (both identical except the title) will only work with
the query including =8.  Whenever I try to open the report for <>8 Access
gets stuck and cannot open the report (no error message).  If I change the
query to = any number the report will run but it doesn't seem to like <>.  I
have now tried to remove the criteria altogether (so that I would get all
"open" results) but that causes problems with the report too although that is
what I had before!

I have tried making a copy of the working report and changing the source to
the other query but the problem persists.

Works: WHERE (((Compl_MAIN_Table.Status)="Open") AND
((Compl_MAIN_Table.[Enforcement Category])=8) AND
((Company_Lookup.Acclaim_Company)<>"Does not belong to Acclaim"))

Does not work: WHERE (((Compl_MAIN_Table.Status)="Open") AND
((Compl_MAIN_Table.[Enforcement Category])<>8) AND
((Company_Lookup.Acclaim_Company)<>"Does not belong to Acclaim"))

I am sure that there must be some obvious answer but it must be lost on me.  
Any direction is much appreciated!  Thanks.