Query limitations with FormSource

You're unable to generate a query with results using the following criteria:

Fields where the value is equal to 0 or where data in a field doesn't exist.
Partial strings of words within a field. You can search for exact matches. For example, if you create a query asking for all tax returns where the taxpayer's occupation is 'teacher,' only returns that use the exact term 'teacher' are returned. Any occupation entered as 'Junior high school teacher' wouldn't be returned.
The Define Query and Define Report tabs store 3,600 characters each. If the field names exceed this amount, you'll get this message,
```
"Report string has exceeded maximum length. Remove some selected fields."
```

Related content