microsoft query
Posted by Keith on January 10, 2002 8:54 AM
I made a external data conection with our Remedy database, but only 6000 records show up no matter what kind of criteria I put in the query and I know there are many more records than 6000, is there a limit to how many records will pull up at a time with microsoft query. Can I use other query programs with excel if this is the case.
Posted by Mark W. on January 10, 2002 10:21 AM
> ...is there a limit to how many records will
> pull up at a time with microsoft query?
Not that I know of. Why don't you produce a count
of the records returned by your query. If the
count is only 6,000 take another look at your
query. Are you joining tables using a field
that contains Nulls? Does your Where clause
use a relational operator on a field that
contains nulls?
