Search results

Thank you Glaxiom - I'll play around with that - your help very much appreciated

btw - yes, I think that is exactly what is happening - it is reconstructing the query and I expect you are right, the problem no doubt lies in the way I have structured things! All help gratefully recieved.

Hi Galaxiom - I have one table which has 58 fields. The fields are a variety of different types (text, numbrs and dates). There are nearly half a million records altogether, not all records have an entry in each field. I want to run a query by form and have a form capturing variables entered by...

I am trying to interrogate multiple fields using one query with two x criteria statements for each field. When I type in the criteria statemnts it all looks fine. When I close the database and go back to the query design there are multiple criteria, the more I add the more complicated it gets to...

Great - thanks guys.

This has probably been discussed but I can't find the answer. I want to query using a form. If a form field is empty I want the query to return all results from the table including null fields. If I query 'Is Null' then it does return the null fields (indicating that the fields are, in fact...