hi, i have a very small and simple database which is used to enter test data for each part per works order no.
each works order number has got 40 products for it so the form i have has got 4 fields, w/o number, type, operator and date.
i then have a subform in datasheet view which is where i enter the data.
with me so far?
one of the fields on the subform is called "pass/fail". this field only contains pass or fail but when i run a query to find all the ones that have failed it comes back with no results............ WHY?????????

Is the field a text firled that contains the words "Pass" or "Fail" or is it a tick / check box? If it is a tick box then the data is stored as True or False so for your query Criteria type in False. If it is text then type in 'Fail' (remember the single quotes for text but no quotes for True / False)

It is a text field and i have tried it with single quotes but still no results