Re: Limiting Rows
From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 10/30/04
- Next message: Sam Carleton: "Conditional consolidation of two fields down to one"
- Previous message: gambler: "Re: RANKING"
- In reply to: Raj: "Limiting Rows"
- Next in thread: Raj: "Re: Limiting Rows"
- Reply: Raj: "Re: Limiting Rows"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 29 Oct 2004 19:52:55 -0600
On Fri, 29 Oct 2004 13:23:02 -0700, Raj
<Raj@discussions.microsoft.com> wrote:
>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
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
- Next message: Sam Carleton: "Conditional consolidation of two fields down to one"
- Previous message: gambler: "Re: RANKING"
- In reply to: Raj: "Limiting Rows"
- Next in thread: Raj: "Re: Limiting Rows"
- Reply: Raj: "Re: Limiting Rows"
- Messages sorted by: [ date ] [ thread ]
