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.
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.