Date / Time and decimal place issue

[ChrisJohns]

Hi all,

Having some trouble with my access table. Date format in my table is presented exactly how i want in short date yet when i export to a text document (via an export specification) it always adds the time to the date of 0:00:00 and i want to avoid this, preferably without creating a query to manually remove it.

I also have a similar problem with a decimal value i have, i've set the format mask to 0.0000 and changed to a double with 5 decimal palces,which has allowed me to pad out my value with 0's to 5 decimal places. Again this is not exporting correctly, and removing all zero's, changing 13.20000 into 13.2

Any help with the above will be greatly appreciated. I imagine it takes a very small fix but im at a loss at the moment.

Many Thanks

 

[boblarson]

To export, don't export the table, export a query with specific formatting for that field:

NewFieldName:Format([OriginalFieldName],"mm/dd/yyyy")

or

NewFieldName:Format([OriginalFieldName],"#0.00000")

 

[boblarson]

Oh and welcome...

 

[ChrisJohns]

wow, such a quick reply. much appreciated

and thanks