MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?