Results 1 to 2 of 2
  1. 11-10-2010, 04:46 PM #1
    kaite07
    kaite07 is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    1

    Max function???

    Figured out max
    Last edited by kaite07; 11-10-2010 at 08:58 PM.
    Reply With Quote Reply With Quote
  2. 11-10-2010, 05:20 PM #2
    TheShabz
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    SELECT TOP 1 PersonID, Number
    FROM mytable
    ORDER BY Number DESC
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. IIf function
    By seb in forum Queries
    Replies: 4
    Last Post: 11-15-2010, 05:28 PM
  2. if function
    By lolo in forum Queries
    Replies: 1
    Last Post: 08-01-2010, 11:38 PM
  3. Help with AVG function
    By techexpressinc in forum Reports
    Replies: 1
    Last Post: 03-23-2010, 07:47 AM
  4. Want function to get current function name
    By Davis DeBard in forum Programming
    Replies: 2
    Last Post: 08-13-2009, 05:02 AM
  5. Sum Function Help
    By newbie in forum Reports
    Replies: 3
    Last Post: 06-30-2009, 05:32 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums