Give us a detailed example, along the lines of:
my table has a field with number - long integer data type, not required.
my query is "..."
The value "..." is in the table, but it is not being returned.
If you can post a sample database (one table, a few rows, one query) that demonstrates the problem, that would be even better.
