[AccessD] Exporting to .txt

Just one more little thing;
There is a field "hours" which when gets transferred to .txt putes . at
the end of numers like 60. or 70.
I'd like to avoid it, i change datatype to text in the table, but result
is the same. Should I do something in the query for it also ?


> SELECT SSN, Format([PayDate], "mmddyyyy"), Format([PeriodEndDate],
> "mmddyyyy"
> FROM op_TALX
>
> Charlotte Foust
>
> -----Original Message-----
> From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com]
> Sent: Friday, December 12, 2003 9:43 AM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] Exporting to .txt
>
>
> Where can I do format ? in sql window of query ?
>
> SELECT SSN, PayDate, PeriodEndDate
> FROM op_TALX
>
> here ?
>
>> You need to do the export from a query and use the format function to
>> change the date to a string of the correct format.  If you just export
>
>> from the table, a date is going to be handled as a date.
>>
>> Charlotte Foust
>>
>> -----Original Message-----
>> From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com]
>> Sent: Friday, December 12, 2003 9:05 AM
>> To: accessd at databaseadvisors.com
>> Subject: [AccessD] Exporting to .txt
>>
>>
>> I need to export a file to either .scv or .txt format with fixed
>> length. There are 2 date fields which should be in a mmddyyyy format.
>> I specify in 'specification' that field should have be in a format
>> MDY, 4 digit year. leading zeros, no dividers, yet I still get
>> 12/7/2003 type results... in txt file..
>>
>>
>> -----------------------------------------
>> Get Breaking News from CNN, ABC, NBC, CBS Now.
>> http://www.xuppa.com/news/?link=webmail
>>
>>
>> _______________________________________________
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>> _______________________________________________
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>
>
>
> -----------------------------------------
> Get Breaking News from CNN, ABC, NBC, CBS Now.
> http://www.xuppa.com/news/?link=webmail
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com









-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail