Queries Based on Query

G

Gastimore

Hi I have a query that return long number of records(over 500000 records), i
want to write sub queries that will return a number of records that I
specify, example query1 will return records 1 to 100000, query2 will return
records 100001 to 200000, query3 will return records 200001 to 300000, etc.

can somebody help me Thanks in advance
 
J

Jerry Whittle

Is there a field with the record numbers or are you talking about any 100,000
records at a time?
 

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

Crosstab query totals 3
Query Counts based on multiple Query criteria 3
loop though records in a query? 5
queries based on queries 6
Removing duplicates when joining 2 queries together 1
Union query - using VBA? 6
Strange problem using VB Code in Query 3
Query based on Query 1

Top