Results 1 to 2 of 2
  1. #1
    mreed is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Sep 2009
    Posts
    1

    Max of several fields


    First post - I have a table containing utility customer hourly usage data. There is a record for each day and a separate field for each hour. I want to be able to find the highest usage amount for each customer. I am able to get the max for each hour, but not the max of the hours.

  2. #2
    NassauBob's Avatar
    NassauBob is offline Not THAT Green
    Windows XP Access 2003
    Join Date
    Feb 2010
    Location
    Augusta, GA
    Posts
    61
    I understand that you do not want to find largest value in one attribute (column), but the largest value of each particular row across all hourly attributes?

    Is that accurate?

    Shane

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

Similar Threads

  1. Replies: 3
    Last Post: 08-10-2009, 08:33 AM

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