Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    10

    Unanswered: Import Number With Following Sign

    I wish to import a txt file where the numbers have a sign (-) following the numbers. How do I get Access to recognize this as a negative number during the import?

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    Code:
    =cdbl(iif(right$([fieldName],1)="-", "-" & left$(len([fieldName])-1), [fieldName]))
    should swap trailing to leading "-" (where "-" exists) in text and convert the text to double.

    so import as text to a temp table and use the above expression in a make table query.

    izy

  3. #3
    Join Date
    Jan 2003
    Posts
    10
    Much thanks.

    How you have a great week!!!

Posting Permissions

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