Results 1 to 9 of 9
  1. #1
    Join Date
    Apr 2005
    Posts
    39

    Unanswered: Export module to text tab delimited

    Hi, I want to export to a text tab delimited file. That is all possible, but I have 4 colums with number in it. The last column I would need to format without decimals. Can I format the numbers somehow in the code. I tried it in the query and in the export specification, but did not work....any ideas?

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    What did you try in the query?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Apr 2005
    Posts
    39
    I tired the round function

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Post the query.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Apr 2005
    Posts
    39
    SELECT TBL_SHIPMENTS.Customernumber, TBL_SHIPMENTS.Salesoffice, TBL_SHIPMENTS.Product, TBL_SHIPMENTS.Curr_code, TBL_SHIPMENTS.Month, TBL_SHIPMENTS.Ship_list_clc_legal, TBL_SHIPMENTS.Ship_list_lc_legal, TBL_SHIPMENTS.Ship_net_clc_legal, TBL_SHIPMENTS.Ship_net_lc_legal, Round([tbl_shipments]![Units],0) AS Units
    FROM TBL_SHIPMENTS;

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    When you run that as a standalone query, what does the Units field end up looking like?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  7. #7
    Join Date
    Apr 2005
    Posts
    39
    There I get the right output. Strange enough in the text file it puts a dot and 2 decimals (zero's)

  8. #8
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Are you looking at the raw text file to confirm format? Is there an intermediate like excel or whathaveyou that could be reformatting?

    Have you tried CInt([yourField])?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  9. #9
    Join Date
    Apr 2005
    Posts
    39
    Hi, no, I just export it directly into a text tab delimited file...

Posting Permissions

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