473,387 Members | 1,512 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Exporting Long Interger w/ no decimals

68
Hi!
I have a table tblExport with a field 'Quantity' which is set to number and long integer. The table looks how I want (w/ no decimal places). When I export my file to .txt comma delimited, it comes out w/ decimal places. Is there a setting I'm missing to get rid of these? Can I export a long integer field to not have decimals? I thought I had it working yesterday, but I came in today and there are decimal places again....
Thanks!
Apr 24 '07 #1
2 7207
MMcCarthy
14,534 Expert Mod 8TB
Hi!
I have a table tblExport with a field 'Quantity' which is set to number and long integer. The table looks how I want (w/ no decimal places). When I export my file to .txt comma delimited, it comes out w/ decimal places. Is there a setting I'm missing to get rid of these? Can I export a long integer field to not have decimals? I thought I had it working yesterday, but I came in today and there are decimal places again....
Thanks!
A Long Integer shouldn't be outputting with decimal places unless the numbers are entered that way. What is the Decimal Places property of the field set to?
Apr 25 '07 #2
I had this pesky problem too. I needed to produce a delimited file for a Regulatory Report Filing... and MSAccess (2003) kept adding .00 to numeric fields. I even set up a query which explicitly rounded the fields to integer values, but the .00's were still added.
The workaround I ended up with was using using a query which used an expression like --- Trim(Str(round([table!column]))). This changed it to a text field.
Jun 23 '12 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: G | last post by:
When I export data from access to excel by with "export" or "Analyze with" I seem to loose parts of some fields (long text strings). Is there a way to export it all to excel? Thanks G
2
by: Brian Daoust | last post by:
Hello everyone, I have an Access database with a table that has a text field. The data in the text field looks like: 3456.45.4343 Not sure why this is a text field, but it is. Anyways,...
4
by: italia | last post by:
I changed the Fieldsize Property from text to Long Integer and Decimal Places = 6. I had decimals in the original field. But after the transfer, the digits after the decimals are gone. Now...
15
by: michael.mcgarry | last post by:
Hi, I have a question about floating point precision in C. What is the minimum distinguishable difference between 2 floating point numbers? Does this differ for various computers? Is this...
5
by: Daniel Rudy | last post by:
How does one covert a interger number in a unsigned long long int (64-bit) to long double (80-bit) storage? I looked at math.h and I found function that convert double to long long, but didn't...
3
by: Chua Wen Ching | last post by:
I have a problem. But on .NET 1.1 My Scenario: Actually I will have a string of hexadecimals read from a xml file. Then from the hexadecimals, i will add 1 value whenever i made any...
2
by: Snozz | last post by:
The short of it: If you needed to import a CSV file of a certain structure on a regular basis(say 32 csv files, each to one a table in 32 databases), what would be your first instinct on how to...
2
by: Coll | last post by:
I have a select query with many fields. One of the field uses a function - LengthService: IIf(False,0,losactives(!)) The field should function as a numeric field. When I export it to excel, I...
1
by: Marty Klunk | last post by:
I have an Access97 data base where we are exporting records out to a text file that is then sent to a customer via EDI transmission. The problem I am having is that during the export process access...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.