QUERY ERROR MORE DATA THAN CAN FIT ON A WORKSHEET - WHY

G

Guest

i am using Excel to retrieve information from an external database. I have
been receiving a message "The query returned more data than can fit on a
worksheet"
I am retrieving the data using invoice numbers in 3 locations, with 3
different series of numbers. It worked for several months, but does not work
this month. The query returns 563 records - there shoul be 1050 (approx).

Criteria is set on invoice numbers "between" for 3 the three different series.
Please help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query returned more data than will fit on a worksheet 5
Query returned more data than will fit 2
How to return more data than will fit on a worksheet 3
query criteria Not Like ... <> 2
Using the "Forms Object" on more than field in a query table 2
Changing the Recourd Source (underlying query) of a report 5
Entering the same data on more than one worksheet 2
Query returns incorrect data 4

Top