Minimum values - code vs. SQL [Resolved]

[salvelinus]

This is part of the same unresoved question I posted in the database forum.
Basically, I need to get the records with the minimum value (in a field named Value ) for each question/module fields combination. I thought there'd only be a few hundred matching records, but there's between 2 & 3 thousand.
I wasn't able to figure out a query to retrieve these records, so instead I used code to loop through recordsets and INSERT records into a table. But it does this one record at a time, and takes a couple minutes to run, as well as tying up the processor.
If there's no SQL to run a regular query for this, is there a way to do a batch INSERT in DAO to speed things up? Thanks.