Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Location
    South Africa
    Posts
    178

    Question Unanswered: export to excel as text

    I'd like to export a report into excel.
    the problem is that when I do this, the field that looks like 1534/021 in the report, gets calculated as 73.0476... in the excel file. how do i export it so that it is exported as text?

    thanks in advance
    ActionAnt

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Before you export your Table make a Query which formats this field to be a Text, and export this Query and not the table

  3. #3
    Join Date
    Jan 2004
    Location
    South Africa
    Posts
    178
    how do I format a field in the query?

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    In the query widow write
    anyName:Format (yourField,"000000")

    For example

  5. #5
    Join Date
    Jan 2004
    Location
    South Africa
    Posts
    178
    thanks but "000000" formats it as a number
    text?

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    CStr(yourField)
    oh yeah... documentation... I have heard of that.

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

Posting Permissions

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