I have a table that has the following fields:



Employee_ID

Date

Time_Entry



These records come from a time clock.  I need to be able to take these

records and put them into a second table with the following format:



Employee_ID

Date

Time_Entry_1

Time_Entry_2



Time_Entry_1 and Time_Entry_2 need to come from the first table.  The first

table can contain multiple records for each Employee_ID on the same Date.  I

need some way to be able to parse through table one and when I find records

for an Employee_ID on a date, take the record with the lowest time entry and

make it Time_Entry_1 and the record with the highest time entry and make it

Time_Entry_2 in the second table.  How can I do this?





John Pace

Manager of Information Technologies

Haws and Tingle General Contractors

650 West Vickery Blvd

Fort Worth, TX  76104

xxx-xxx-xxxx

Fax:   xxx-xxx-xxxx

E-Mail:  jpace@h...

www.hawstingle.com