How can I conver the output of the attached table to this format:

.........1/1/2010 1/2/2010 1/3/2010 1/4/2010.....4/30/2010
A4749 10 12 10 8
A3412 8 10 10 10

I need to view the schedule across the page so I can display it on a web page...
The number of logins and the dates are infinite, so I cannot hard code anything...

I see the above format is messed up, what I need is to run the dates across the top quarterly and have the login down the left of the page with the shift for each login in its proper place.

Thanks,
Dave

You may find this post useful (http://www.access-programmers.co.uk/forums/showthread.php?t=71302)