Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unanswered: problem with data type

    Hello , I am using MS Access and I have a problem with Data Type

    I have a field with data type varchar in my table

    I want to convert to integer in my query

    But I can`t ....

    In MS SQL I used

    SELECT CONVERT(char(20), myfield) as myfield FROM mytable

    It is working !

    But it is not working in Microsoft Access ...

    Who know ? What is a problem ?

  2. #2
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Smile Re: problem with data type

    Originally posted by eLs
    Hello , I am using MS Access and I have a problem with Data Type

    I have a field with data type varchar in my table

    I want to convert to integer in my query

    But I can`t ....

    In MS SQL I used

    SELECT CONVERT(char(20), myfield) as myfield FROM mytable

    It is working !

    But it is not working in Microsoft Access ...

    Who know ? What is a problem ?
    In Access use the CInt(myfield) to convert to integer.

  3. #3
    Join Date
    Oct 2003
    Posts
    2
    Thank you very much for help , my friend .

Posting Permissions

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