Outputting results from Access VBA Module to a Table

[cdipaolo]

I am stepping through a recordset and along the way find records that I want to send to a table or some type of report - what is the syntax for doing this? Do I need to save the records in an array and wait until I am done, then open a new recordset to update a table with the records in the array?

Thanks in advance...

Chris

 

[RJFost]

If you're testing records/data against some defined criteria (e.g., HOURS > 40, YEARS <= 5, etc.), why not just write an INSERT query to copy the records that satisfy the criteria into another table?

 

[cdipaolo]

Thanks for the suggestion, but the criteria is complicated and depends on the record before and after it (when sorted correctly).

It turns out I'm going to put an OWC.Spreadsheet object on a form and display it that way.

Thanks again.