I need help with some VB or SQL programming for a database.

I need some VB or SQL coding to finish up an access database program. I am
trying to choose selected records from an access table based on certain
criteria. Example: 2 records needed out of 4 total records and the code
should choose the 2 records with the lowest value amount in another
field.
Name Hours
Jane 5
John 8
Martha 10
Paul 10
The codes nees to pick out Jane and John and append them to another
table.
Please help! WOuld be much appreciated!

Assume you know how to execute SELECT SQL statement, try this:

SELECT TOP 2 Hours,[Name] FROM theTable ORDER BY Hours DESC

"Jparrish67" wrote in message

 > I need some VB or SQL coding to finish up an access database program. I
am
 > trying to choose selected records from an access table based on certain
 > criteria. Example: 2 records needed out of 4 total records and the code
 > should choose the 2 records with the lowest value amount in another
 > field.
 > Name Hours
 > Jane 5
 > John 8
 > Martha 10
 > Paul 10
 > The codes nees to pick out Jane and John and append them to another
 > table.
 > Please help! WOuld be much appreciated!
 >