How to group records together based on time and date

[csc123ster]

I have an access table w/ the following fields
id
user
session_count
clientaddress
clientname
sessionstarted
sessionended
duration

How can I create a query that will create the following results?

4/3/08
12am
1am
ClientName SessionStarted SessionEnded Duration
2am
3am
4am...
4/4/08
12am
1am
2am
3am...

TY for the help and advice

[FishVal]

Hi, there.

Your question is somewhat unclear. Could you explain in words what your table is all about and what would you like to see in the query?

Kind regards,
Fish.

[csc123ster]

Fish,

Here is the format and table & record

Field Record
User webdim\user1
Session_count 9
ClientAddress 172.33.22.34
ClientAddress WI_sece
SessionStarted 4/3/2008 4:21 AM
SessionEnded 4/3/2008 4:21 AM
Duration 0:01:14

I want to group all the users by hourly and daily

thnks

[FishVal]

And what have you tried so far to achieve this?

Kind regards,
Fish.