HI 

I am having a big problem with how to pick information from an access 

database.

I have a database with following columns.

From date:     From time:      To date:       To time:



All kolumns are in date/time format an I would like to pick out specific 

information like

2001-05-25  at 07:00 will steven begin to work and end his work at 2001-05-

28 06:59 and 2001-05-28  at 07:00 will sara begin to work and end at 2001-

06-01 at 06:59 and so on.

What do I ´want to do?? 

I want that each person show up the webpage when they working and just one 

person at the time.

Today I write like this and it's workin but just with date and when i put 

in the time it all goes crazy(not working).



<%Response.buffer=true%>

<%session.lcid=1053%>

<%dim rs,recset,sql,connect,datum,tid

Set Connect = Server.CreateObject("ADODB.Connection")

'Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & 

Server.MapPath("Vhi.mdb")

connect.open("vhi")

datum=formatDateTime(date, vBShortdate)

tid=formatDateTime(time, vBShorttime)

sql="select fnamn,enamn,foto,DatumFran,DatumTill from Datum inner join VHI 

on Datum.Vhiid=VHI.Vhiid WHERE DatumFran <= '"&datum&"' AND DatumTill 

>= '"&datum&"' ;"

set recset=connect.execute(sql)

%>



can some please help me with this I would be so very happy.



Roger