Counting A Recordset

[fpendino]

Is it possible to count how many records are selected in an Append Query using a recordset count?
Or will I have to make the sql statement into a select query before I am able to use the recordset function?

Also, I need to know this exact way because I have other functions bases solely off whether there are records in the append query, therefore I can't just use the append message box for what I am doing.

Thanks!!

 

[dcx693]

I don't think there is a way to get the number of records to be appended with an append query because the query is executed, not opened. I think you'll have to do as you suspected, open the query first as a select query.

 

[pbaldy]

If you can wait until the query has run, you could use the RecordsAffected property (presuming you're using a stored query) to get a count on how many records were appended.