Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Location
    Belgium
    Posts
    243

    Question Unanswered: Right-statement from Access2003 not working in XP

    We have a database made with access 2003.
    There is a textfield (Date) containing the date (eg 20040326)
    To extract the day of it (26) we used Right(Date;2).
    It works fine with access 2003, but gives an error using access XP saying :

    "Expression gives an undefined fuction Right"

    Anyone any idea how we can solve this without upgrading everyone to access 2003?

    Thanks

  2. #2
    Join Date
    Jan 2004
    Posts
    492

    Re: Right-statement from Access2003 not working in XP

    Originally posted by artemide
    We have a database made with access 2003.
    There is a textfield (Date) containing the date (eg 20040326)
    To extract the day of it (26) we used Right(Date;2).
    It works fine with access 2003, but gives an error using access XP saying :

    "Expression gives an undefined fuction Right"

    Anyone any idea how we can solve this without upgrading everyone to access 2003?

    Thanks
    2 thoughts-

    Date is usually a reserved keyword - im surprised they let you name a column Date. Also I think you are looking for a comma between the column and length instead of a semi-colon.

    Try those 2 and hopefully one of the 2 will work.

  3. #3
    Join Date
    Nov 2002
    Location
    Belgium
    Posts
    243

    Re: Right-statement from Access2003 not working in XP

    Originally posted by ss659
    2 thoughts-

    Date is usually a reserved keyword - im surprised they let you name a column Date. Also I think you are looking for a comma between the column and length instead of a semi-colon.

    Try those 2 and hopefully one of the 2 will work.

    The date-issue was just in my explanation, in real life we use DDMMYYYY instead. Sorry.

    And I did use a semi-colon.

  4. #4
    Join Date
    Jan 2004
    Posts
    492

    Re: Right-statement from Access2003 not working in XP

    Originally posted by artemide
    The date-issue was just in my explanation, in real life we use DDMMYYYY instead. Sorry.

    And I did use a semi-colon.

    No, I think you want a comma INSTEAD of a semi-colon. The semi-colon will give you an invalid syntax error.

  5. #5
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266
    Could be a reference problem. Check for any missing references.

Posting Permissions

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