Database Results as Calendar Format

[jennuhw]

I have a database that keeps track of people punching in and out. I want to have a query return data in a calendar type format such as:

Monday Tuesday
6/23/2003 6/24/2003
In Out In Out
08:00 12:00 07:30 10:30
12:30 04:30 11:30 12:30
01:00 03:30

The amount of punches can very from day to day. And some days there might not be any, and I would like them to show if possible. I am not quite sure where to start. Any suggestions would be appreciated! Thanks.

 

[DRowland]

If I understand the question, you're trying to display the results in columns, as in a calendar, with the different days listed horizontally.
Try visiting this site

http://home.att.net/~codelibrary/FrontPage/multi.htm

It gives all the details on how to set up columns on an asp page.