Access datum/tijd veld probleem

Hello everyone

I am busy with the analys of a Microsoft Access database. But the database isn't logical/build correct. So I have some problems with some fields

I have a table with information about which pages anyone has visited. Now I would like to count howmany sessions any user has done. The rule is that there is only one session per user per day. There are to many records to count them manully.

The problem is that the date en time information is put into one field Like this "08-05-2001 13:00:50". So every record is unique. Which makes a query not easy. Is there a simple way to remove the time-factor or make two colums, one with the date information and one with the time information.

So A count is possible.

Example of the information:

ID Timestamp pages
1000 08-05-2001 13:05.00 URL
1000 08-05-2001 16:00:00 URL

This would mean that Access count this as two unique records, also If I only selected the ID and Timestamp. The Time is the problem.

Is there someone, who can tell me how I can easily remove the time or split the date/time.

I am also looking for a method, to count the average (AVG) of the time per session per user.

I hope that there are people overhere who can help me out, because I don't know it anymore.

Johan.

Problem solved