Matching Time-In and Time-Out based on 3 fields

A

Arlene

I have a table that has the following field: ID, Course, Dte and Time. Is
there a way to create a new table out of this and group the ID, Course, Dte
fields - then sort the time and create a table with ID, Course, Dte, plus 2
new fields Time-In and Time-Out. Below is my sample current table and desired
output:

Current Table:

ID Course Dte Time
100 ENGL 104 01/12/2007 8:00
100 ENGL 104 01/12/2007 9:00
100 ENGL 104 01/12/2007 13:00
100 ENGL 104 01/12/2007 14:00
200 MATH 120 01/12/2007 10:00
200 MATH 120 01/12/2007 11:00
200 CHEM 142 01/12/2007 12:00
200 CHEM 142 01/12/2007 15:00

Desired New Table:

ID Course Dte Time-In Time-Out
100 ENGL 104 01/12/2007 8:00 9:00
100 ENGL 104 01/12/2007 13:00 14:00
200 MATH 120 01/12/2007 10:00 11:00
200 CHEM 142 01/12/2007 12:00 15:00

Thank you in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top