>No question is stupid when you are dealing with something like this!!! Sorry you've had a bad couple of days too!!!
>
>I have discovered something... The field is logical and is indexed (I need it to be indexed!!!) but I thought "What the heck!!!!" and removed the index - MS Query now returns the reocrds!!!??? I have no idea why this has worked but it still causes me a problem as I need the field to be indexed... Mad!!!
May I be curious: why would anybody need to index a logical field? I never did that.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)