Limiting Rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that I use for a lookup in another datbase. I have over
100,000 row in my database. If there away to have the query run on the 500
row and then then next 500 until it gets to the end?
TIA
 
I have a query that I use for a lookup in another datbase. I have over
100,000 row in my database. If there away to have the query run on the 500
row and then then next 500 until it gets to the end?
TIA
Click to expand...

A "lookup" query doesn't "run". You're thinking procedurally, not in
sets! Could you explain how the tables are related? What are you
looking up that has 100,000 different values?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
John,
The fields are related by equipment id and customer account number. I get a
spread sheet with equipment id and customer account number. I import this in
to my database and use DLookup to get the vendor for the equipment id and the
customer account to get the customer name from a link to an Oracle database.
Where there are more than 500 records in the table I get an connection
error. what I would like to do is have it look up 500 and then the next 500.

Thank you..
 
John,
The fields are related by equipment id and customer account number. I get a
spread sheet with equipment id and customer account number. I import this in
to my database and use DLookup to get the vendor for the equipment id and the
customer account to get the customer name from a link to an Oracle database.
Where there are more than 500 records in the table I get an connection
error. what I would like to do is have it look up 500 and then the next 500.

Thank you..
Click to expand...

I don't think I understand. Could you post your code? How are you
doing the "look up"?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top