Export number without decimals

[Guest]

hI,

When I export my data from a query in csv format, one of the fields which
has 13 digit numbers diplays decimal places when infact the data in the
database does not have any decimals.

How can I force this field in my query to format with zero decimals so it
exports correctly.

Eg.
currently doing 1310010010011.00
want to show 1310010010011

Bruce

 

[Jeff Boyce]

Bruce

It might be a bit of a kludge, but you could convert the number to text
(CStr()) in a query before exporting the query.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/