Query gives extra records

[pbassett]

I have a query with criteria "Contractor-Exp Hours"
Amazingly, it returns records with "Contractor-Cap Hours" in addition to what I want (Exp only). How can I limit the results - I can't understand why I get the extra records.

 

[Norie]

Can you post the SQL for the query?

 

[pbassett]

SELECT A.TYPECODE
FROM A
WHERE
(((A.FUNDINGYEAR)=2005) AND
((A.TYPECODE)="Contractor-Exp Hours"));

Actually, I tried again and it seems to run OK now. Not sure why. I will post again if it recurs.