Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    1

    Unanswered: Undefined Function Mid in Expression

    I have written a statement within a select query that modifies the format of a date value form 00000000 to 00/00/0000

    Date of Birth: IIf([Date_Of_Birth]="00000000","",DateValue(Mid([Date_Of_Birth],7,2) & "/" & Mid([Date_Of_Birth],5,2) & "/" & Mid([Date_Of_Birth],1,4)))

    But receive the error:

    Undefined Function Mid in Expression

    Can anyone help?

    thanks

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Check your preferences...

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    or even your references

    open a form in design mode, view the code and then tools | references

    make sure that the VBA library is missing, and try to resolve any missing references
    HTH

Posting Permissions

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