C
coconut78
OK, from Access, I have a table that is exported into an Excel Workbook.
This workbook, an attendance log, is formatted as follows:
Child1 TimeIn TimeOut Date
Child2 TimeIn TimeOut Date
Child3 TimeIn TimeOut Date
Child1 " " "
Child2 " " "
Child3 " " "
I have linked a completely different Excel Workbook to this workbook, and
want to change the format to:
Child1 Child2 Child 3
Date TimeIn TimeOut TimeIn TimeOut TimeIn TimeOut
Date TimeIn TimeOut TimeIn TimeOut TimeIn TimeOut
How do I search the export from access to match BOTH the Date and the Child
to find the TimeIn and TimeOut?
This workbook, an attendance log, is formatted as follows:
Child1 TimeIn TimeOut Date
Child2 TimeIn TimeOut Date
Child3 TimeIn TimeOut Date
Child1 " " "
Child2 " " "
Child3 " " "
I have linked a completely different Excel Workbook to this workbook, and
want to change the format to:
Child1 Child2 Child 3
Date TimeIn TimeOut TimeIn TimeOut TimeIn TimeOut
Date TimeIn TimeOut TimeIn TimeOut TimeIn TimeOut
How do I search the export from access to match BOTH the Date and the Child
to find the TimeIn and TimeOut?