Count query records

  • Thread starter Thread starter Malvina
  • Start date Start date
M

Malvina

I am trying to output my query results to excel. The
amount of records I may have in the query more then 65536,
which is greater then row count in excel in one sheet.
Most likely, I will output my results to more then one
excel spreadsheet. I need to divide the query records,
and use the records partially. I know, how I would count
my records in the recordset:

Set rs = CurrentDb.OpenRecordset("Select count(*)AS
RowCount FROM qryDailyFinal", dbOpenSnapshot)

And again, I don't think that is what I am looking for.
Is there a way in splitting the recordset and use partial
records to copy to excel?

Thank you in advance,

Malvina
 
Get the query to include a primary key value from one of the tables
involved. Then do the query twice: once where PK < "H", then again where PK
= "H" (or whatever: I'm sure you get what I mean).
Click to expand...

HTH,
TC
 
Back
Top