limiting queries

[jeanluc]

Hello,

I have a database that contains 330k records.
These records are grouped into several queries of ~65k records each.

I need to export these queries into text files for import into another application. Here is the kicker, The app will only accept text files of ~250 records each. The oly way I can think of is to export the entire query, bring it into Excel and cut-paste the file 250 records at a time(NOT FUN).

Is there a way to limit either query or the export??

Ciao,

Jean Luc

 

[Rich]

You can limit any query just by adding criteria to one of your fields. Say on a date field Between[StartDate]And [EndDate] as an example.
HTH