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!!!