Counter Field

  • Thread starter Thread starter Hendrix10
  • Start date Start date
H

Hendrix10

I have a query that I would like to export into excel but the number
of rows (100,000+) is more than excel can take. So, I would like to
add in a counter field so that I can have ensure that I export all the
rows. How would I do this? Also, if there is a better way to go about
this please let me know.

The reason i will be exporting to excel is to do some basic sub
traction of rows.
 
Well the new Excel 2007 file format can handle a million rows. That could be
an option if everyone using the spreadsheet also has E07.

Other than that, why not just split up the data with a query. Something like
the following in the criteria of one query:

LastName < "L"

And the following in the other:

LastName >+ "L"
 
Back
Top