Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to query and group results by date/time

Status
Not open for further replies.
csc123ster

csc123ster

IS-IT--Management
Apr 3, 2008
2
US
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
 
Sort by date Sort by votes
It would be best to post in forum701. It would be a good idea to include some sample data when you do.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

I
  • Question
How to get 2 codes to work together.
Replies
6
Views
357
hermanlaksko
hermanlaksko
monkeysee
  • Locked
  • Question
Combo Box - Limit results
Replies
1
Views
362
dhookom
dhookom
TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
531
TomSalvato
TomSalvato
caykamanj1966
  • Locked
  • Question
Help With Search Form Results 2
Replies
15
Views
323
caykamanj1966
caykamanj1966
TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
526
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top