Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Amersfoort, Utrecht, Netherlands
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    #error on text functions (97)

    Hello all,

    I have a big database where I run a query to extract some text from a textfield. I use the expression code : left([Pcode]);4)
    When running the query it is giving me a #ERROR result
    When I try some other functions like MID() or RIGHT() it gives the same result. The LEN() function gives a good result.
    So I thought that the table was corrupt, after building a new table and query the result was the same
    Even repairing the database was no solution.

    Finnaly a build a new database and linkt to the tables of the problemdatabase and created a new query. This time the result was good.
    So I now create a new database and import all the tables form the problemdatabase and problem solved

    ... so why posting this problem...

    I just want to know what the reson could be that those functions where not working.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: #error on text functions (97)

    Most probably, the old database was corrupt in a way that Compact and Repair Database couldn't correct. Importing all tables into a new database is often (not always, unfortunately) a good way to recover the data from a problem database.

    There is also a smal chance that there was a problem with references in the old database, but you'd probably have got error messages then, instead of just #ERROR.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: #error on text functions (97)

    Your function has an extra parenthesis in it. I think it should be:

    <pre>left([Pcode];4)
    </pre>

    Legare Coleman

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: #error on text functions (97)

    Good catch!

  5. #5
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Amersfoort, Utrecht, Netherlands
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: #error on text functions (97)

    sorry, that was a typo in the message, the function was correct in Access.

Posting Permissions

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