query options

[lhather]

I hope this is a very simple query question. I've searched the Access forum but didn't find exactly what I'm looking for.

I have a query that pull data from 3 tables (two are linked). This query generall produces about 50,000 records. I need to then export the query results into spreadsheet - ultimately ending up in Lotus Format. The problem is that the max number of records for Lotus format is 8,000.

Can I specify in say multiple queries the first 8,000 results and then result 8,001-16,000, etc. I hope this is clear enough for all to understand.

Thanks in advance.

 

[Corticus]

Hi,

You could add a count field in your query:
http://216.92.17.166/board2/viewtopic.php?t=41858

and then set the criteria of the count value to <8000, >8001 and <16000, etc...

Do you really need to go into Lotus? Ack.

HTH,

 

[lhather]

Not working - need clarification

I think I'm doing it wrong. Should I be selecting the Totals option in a new column in my query or an existing column (field) The totals option runs across all the fields.

The best I could come up with is and additional field in my results that says count of (field of choice) and it has 1's going all they way down.

If I set the criteria @ <8000 - it gives me a datatype error.

 

[Corticus]

Yes,

I apologize for pointing you to a post that I did not test. I will get back as soon as I think of something. I want to number the records in the query, and then use criteria, it should work then.

-C

 

[Corticus]

top

Hi Ihather,

I hope I'm not too late.

If you use the 'top' condition in SQL, you should be able to do what you want.

SELECT top 8000 Qry1.Field1, Qry1.Field2
FROM Qry1;

hats off to Thoey for this one

You can make this a 'make-table' query, or whatever you need to put the dat where you want.

HTH,