Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2000
    Location
    Massachusetts, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DMax Function on a text field (A97/SR2)

    I have a Check Number field that is defined as text that I would like to do a DMax function on but it is returning 999 as the highest value when there are check numbers like 1001 that I need it to return. I know that it's because it's handeling it as alphnumeric but don't know how to get around it.
    I tried Format - Format(DMax("[Check]", "tbl_Check"), "00000"). I also tried Val - Val(DMax("[Check]", "tbl_Check")) but neither return check 1001.

    Any help is greatly appreciated.

  2. #2
    Lounger
    Join Date
    Nov 2001
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DMax Function on a text field (A97/SR2)

    Why not change the field to Long Integer?

  3. #3
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DMax Function on a text field (A97/SR2)

    Try - DMax("CLng([Check])", "tbl_Check")

  4. #4
    New Lounger
    Join Date
    Dec 2000
    Location
    Massachusetts, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DMax Function on a text field (A97/SR2)

    Problem Resolved.

    Thanks to both of you for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •