Pull from Access

[Dave]

Hello, I want to pull 3 different types of date and time driven information
from a database and have to open 3 connections. I will show this information
as a calendar type function when people login. Each person will have
different data show on the first page of the website based on their login. I
need to create a table with 4 columns, first one will be the time by 1/2 hour
for a 24 hour time period. The second, third and fourth column will be dated
and timed information, but each from different tables. (so there will be 48
rows, 1 for each 1/2 hour.) Another problem is that there may be 2 bits of
data for the same day and time to appear under one section, which would make
that section bigger than the others. So I cannot have 4 seperate tables.

Any suggestions?

Thanks,
Dave

 

[Stefan B Rusynko]

Doable w/ custom ASP coding - not just the DBW
- not sure why you need 3 connections - rethinking your DB layout
- what about summary info in main table and links to details for multiple events at same time



| Hello, I want to pull 3 different types of date and time driven information
| from a database and have to open 3 connections. I will show this information
| as a calendar type function when people login. Each person will have
| different data show on the first page of the website based on their login. I
| need to create a table with 4 columns, first one will be the time by 1/2 hour
| for a 24 hour time period. The second, third and fourth column will be dated
| and timed information, but each from different tables. (so there will be 48
| rows, 1 for each 1/2 hour.) Another problem is that there may be 2 bits of
| data for the same day and time to appear under one section, which would make
| that section bigger than the others. So I cannot have 4 seperate tables.
|
| Any suggestions?
|
| Thanks,
| Dave