I have an Access2000 database. The table includes the fields StudentName, Coach, Session1Date, Session1Hours, Session2Date, Session2Hours up to Session24. I need to write a query that shows all the sessions a coach did over the space of a week including the StudentName SessionDate & SessionHours. It would look like this: COACH STUDENT DATE HOURS Bill Jones M Smith 25-10-03 2 Bill Jones R Thomas 27-10-03 1 Mike Robert B Gates 29-10-03 2
Sample access database with the above query. Please note I have reasonably advanced Access skills and this is not as straight forward as it looks!
Windows, Access 2000