Results 1 to 4 of 4
  1. #1
    Arty is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2009
    Posts
    2

    Unhappy Peak data usage of the day

    Hello,

    I have a table where I need to get of everyday the peak data usage.
    the table look like this:
    Date( Time) , Name , Data Usage,
    2009-01-01 00:00:00 , Client1 , 1234567,
    2009-01-01 00:00:00 , Client2 , 7654321,


    ect
    ect

    How can I get the the peak data usage of a client every day?

    Thank you

  2. #2
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    Group by client by date sort by date by client ascending and usage descending in a query

  3. #3
    Arty is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2009
    Posts
    2
    I think i didn't explain it good.

    I have a list of a lot of clients every day
    The thing is that i want to know which client has the max usage data every day.

  4. #4
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    If you group by date ans sort by usage descending

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 09-25-2008, 12:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums