Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2006
    Posts
    4

    Max formula in Access

    hi there



    I used the function MAX(num1,num2) to get the max value in same table, same column, but different row;

    Max:max(IN_30min,OUT_30min)/1000

    but i got the" The expressions you entered has a function containing the wrong number of arguments"

    can somebody help me on this please

    br, mohsin

  2. #2
    Join Date
    Jun 2005
    Location
    Northampton, England
    Posts
    14
    You can't use the MAX function that way. Have a look in the help for the correct usage.

  3. #3
    Join Date
    Dec 2006
    Posts
    4
    Hi

    can you advise me how?!, please

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

Similar Threads

  1. Complex Date Comm/Amt Formula
    By JLongo in forum Programming
    Replies: 0
    Last Post: 11-21-2008, 10:24 AM
  2. user formula setup
    By elios115 in forum Access
    Replies: 2
    Last Post: 08-09-2008, 06:40 AM
  3. formula on report??
    By dike969 in forum Access
    Replies: 0
    Last Post: 03-05-2007, 01:58 AM
  4. form formula to combine two fields
    By InvGrp in forum Forms
    Replies: 1
    Last Post: 10-20-2006, 12:10 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