Page 1 of 3 123 LastLast
Results 1 to 15 of 32
  1. #1
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts
    For some reason I get the following message when trying to run a query with "SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)" as the Field to append to a table:

    "Function is not available in expressions in query expression 'SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)'."

    Any ideas what would cause this?

    Thanks,




    Ken
    Attached Images Attached Images

  2. #2
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts
    For some reason I get the following message when trying to run a query with "SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)" as the Field to append to a table:

    "Function is not available in expressions in query expression 'SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)'."

    Any ideas what would cause this?

    Thanks,




    Ken

  3. #3
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts
    For some reason I get the following message when trying to run a query with "SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)" as the Field to append to a table:

    "Function is not available in expressions in query expression 'SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)'."

    Any ideas what would cause this?

    Thanks,




    Ken

  4. #4
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts
    For some reason I get the following message when trying to run a query with "SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)" as the Field to append to a table:

    "Function is not available in expressions in query expression 'SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)'."

    Any ideas what would cause this?

    Thanks,




    Ken

  5. #5
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts
    For some reason I get the following message when trying to run a query with "SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)" as the Field to append to a table:

    "Function is not available in expressions in query expression 'SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)'."

    Any ideas what would cause this?

    Thanks,




    Ken

  6. #6
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts
    For some reason I get the following message when trying to run a query with "SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)" as the Field to append to a table:

    "Function is not available in expressions in query expression 'SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)'."

    Any ideas what would cause this?

    Thanks,




    Ken

  7. #7
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts
    For some reason I get the following message when trying to run a query with "SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)" as the Field to append to a table:

    "Function is not available in expressions in query expression 'SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)'."

    Any ideas what would cause this?

    Thanks,




    Ken

  8. #8
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts
    For some reason I get the following message when trying to run a query with "SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)" as the Field to append to a table:

    "Function is not available in expressions in query expression 'SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)'."

    Any ideas what would cause this?

    Thanks,




    Ken

  9. #9
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Do you have any VBA in your database? If so, one cause of this sort of issue is a missing reference in VBA. I presume you are assembling just the digits from a field that stores SSNs with dashes in position 4 and 7.
    Wendell

  10. #10
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Do you have any VBA in your database? If so, one cause of this sort of issue is a missing reference in VBA. I presume you are assembling just the digits from a field that stores SSNs with dashes in position 4 and 7.
    Wendell

  11. #11
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Do you have any VBA in your database? If so, one cause of this sort of issue is a missing reference in VBA. I presume you are assembling just the digits from a field that stores SSNs with dashes in position 4 and 7.
    Wendell

  12. #12
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Do you have any VBA in your database? If so, one cause of this sort of issue is a missing reference in VBA. I presume you are assembling just the digits from a field that stores SSNs with dashes in position 4 and 7.
    Wendell

  13. #13
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Do you have any VBA in your database? If so, one cause of this sort of issue is a missing reference in VBA. I presume you are assembling just the digits from a field that stores SSNs with dashes in position 4 and 7.
    Wendell

  14. #14
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Do you have any VBA in your database? If so, one cause of this sort of issue is a missing reference in VBA. I presume you are assembling just the digits from a field that stores SSNs with dashes in position 4 and 7.
    Wendell

  15. #15
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Do you have any VBA in your database? If so, one cause of this sort of issue is a missing reference in VBA. I presume you are assembling just the digits from a field that stores SSNs with dashes in position 4 and 7.
    Wendell

Page 1 of 3 123 LastLast

Posting Permissions

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