Re: Exporting wizard truncates value

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Eric (anonymous_at_discussions.microsoft.com)
Date: 05/04/04 

Date: Tue, 4 May 2004 06:18:53 -0700

This works, however, the export from the querry has a
bunch of junk in it I do not need. I need a tab delimited
file with no column headers.

>-----Original Message-----
>Hi Eric,
>
>Create a query that uses calculated fields to format the
numbers the way
>you want, e.g.
> fMyField: Format([MyField], "0.000000")
>Then export the query.
>
>On Mon, 3 May 2004 10:58:37 -0700, "Eric D"
><anonymous@discussions.microsoft.com> wrote:
>
>>I have a numeric field that needs to be formatted as six
>>decimal places long. I have tried defining the field
size
>>to both single and double. However, when I export the
>>table (tab delimited text file) using the export wizard,
>>the fields are truncated to two decimal places. How can
I
>>get the data export to export to six decimal places?
>
>--
>John Nurick [Microsoft Access MVP]
>
>Please respond in the newgroup and not by email.
>.
>

Relevant Pages

  • Re: Change field names to first row of table
    ... I run a delete query to remove the junk lines ... unusual for the Column Headings to be split over two rows, ... or, perhaps, depending on the format of the data that is being ...
    (comp.databases.ms-access)
  • Re: [PHP] Query question
    ... I have a MySQL database with a date field and a bunch of other fields. ... date field is in the format - 01/01/2006. ... just enter it in the db and then hopefully do the query on it. ...
    (php.general)
  • Query question
    ... I have a MySQL database with a date field and a bunch of other fields. ... date field is in the format - 01/01/2006. ... just enter it in the db and then hopefully do the query on it. ...
    (php.general)
  • Re: formatting a calculated number field on a form
    ... > A query in an MDB file CAN call a user-defined function. ... > function name is Age and it returns a double. ... The user will certainly "notice" if a patient was born on Jan ... I just want control over the *display format* of a number ...
    (microsoft.public.access.forms)
  • RE: Query count then average.
    ... What was happening in my database was the query returned the ... "Ken Sheridan" wrote: ... It probably depends where you set the Format property. ... "Robert F." ...
    (microsoft.public.access.queries)