Conversion Problem - Text to Exponential

I know that the Subject might be a little off, but here's my issue.

I am importing data from a spreadsheet into an Access database. In
this particular column of data, the data looks like this: 911B00,
91FT20, 911000, 91E000.

My issue is that when I import that column if data, for some reason it
takes the records with a "E" (like 911E00) and displays them as
exponential numbers and displays "9.10E+01" - how can I prevent Access
from doing that - or what function can a put in a query to fix that?
0
Commish
12/7/2009 10:50:51 PM
access.queries 6343 articles. 1 followers. Follow

1 Replies
1431 Views

Similar Articles

[PageSpeed] 4

On Mon, 7 Dec 2009 14:50:51 -0800 (PST), Commish
<mark.wolven@gmail.com> wrote:

Sometimes Access is trying a bit too hard.
I am assuming this is a Text column. You may still want to force the
issue with:
select CStr(myField) from myTable

-Tom.
Microsoft Access MVP


>I know that the Subject might be a little off, but here's my issue.
>
>I am importing data from a spreadsheet into an Access database. In
>this particular column of data, the data looks like this: 911B00,
>91FT20, 911000, 91E000.
>
>My issue is that when I import that column if data, for some reason it
>takes the records with a "E" (like 911E00) and displays them as
>exponential numbers and displays "9.10E+01" - how can I prevent Access
>from doing that - or what function can a put in a query to fix that?
0
Tom
12/8/2009 2:10:30 PM
Reply:

Similar Artilces:

Conversions
Hello! I work as an Information Specialist. Majority of our job requests involve conversions. We just received an Adobe Acrobat pdf in which the original document was created in MAC OS. The conversion was successful through Omni Page as we only needed to capture text to convert to a Word document. I was wondering is there any other suggestions you can recommend for conversions from other softwares such as MAC. Thanks so much for your time. A PDF file is a PDF file, no matter which OS was used when the file was created. If you want conversions for specific Mac formats t...

Finding a Specific record problem
I am trying to go to a specific record on a form that opens when a user clicks on a certain control on a parent form. Problem is I can't get it to go to the specific record. Instead I get the following error "Microsoft Office Access can't move the focus to the control id.". Below are 2 methods of code I used but both return the same error. What am I doing wrong??? Method 1: Dim stDocName As String Dim getathlete As Integer getathlete = Me![athleteid1] stDocName = "Cyclists" DoCmd.OpenForm stDocName ' open form when control is c...

VC6 -> VC2005 conversion problem
Hello, I'm converting my project from VC++6 to VC++2005. among many compilation errors now solved, that one is stucking me : I have that template : template <class T> class TLineApproximator { public: //! \name Structures and typedefs //@{ //! 2D homogenous point struct SHomog { public: SHomog(T _x=0, T _y=0, T _w=1) { x=_x; y=_y; w=_w;}; T x; T y; T w; }; //! 2D point struct SPoint { public: SPoint(T _x=0, T _y=0) { x=_x; y=_y;}; static void CrossProduct( const SPoint& p, const SPoint& q, SHomog& r) { r.w = p.x * q.y - p.y * q.x; r.x...

Problem Connecting to Exchange Server from Outlook
Hello all, I'm having a problem with some of our staff systems running Outlook 2003 connecting to our Exchange 2007 server. When they add the server name and their username and then click the "Check Name" button, they receive a message that states: The action could not be completed. The connection to the Microsoft Exchange Server is unavailable. Outlook must be online or connected to complete this action. I've read several posts that discusses possible solutions to this error and I've tried most of them with no success. The staff systems are in a remote offi...

Formatting problems
I have a bar graph with two axis. On axis x the bars are showing and there are no data labels. On the y axis the bars are hidden and there are data labels. I formatted the data labels, saved the spreadsheet and closed it. When I opened it this morning, all of my other formatting was saved, but not the formatting to the data labels. Anytime I close the spreadsheet, it does not save the data label formatting. Any suggestions? ...

A few problems involving LOOKUP and SUMPRODUCT...
Hi all, I am putting together a spreadsheet for a weight watching club. There are 6 members, and a weight entry will be recorded each friday from 08/01/10 - 01/04/10. The weight will be entered in total lbs e.g. 142.25 and the data range is B26:N31. Each members weight will be recorded in this range, i.e. Andrews weight will be tracked in row 26 from cells B to N as the weeks go by. I have then converted the total weight in lbs to stones and lbs as this is easier for everyone to understand. The formula i have used for this is as follows: =INT(SUM(B26)/14)&" st &...

Postcard conversion...
I have been printing 5 1/2 x 8 1/2 cardstock postcards and would now like to convert my 2 per page size to 4 per page or 4 x 6 size postcards. How can I convert my larger graphics and text w/o having to go thru the madness of cutting, pasting, and resizing everything to the smaller size postcard? Thanking you in advance. Frank Engels ...

Outlook problem #48
I am not sure how I did it, but all of the "subject" columns disappeared from emails in one main folder containing 6 sub-folders. How do I get the subject column back without having to click on the individual sub-folders? I know how to it for each folder, but I dont see how to apply the setting for all sub-folders... This is a common problem, Outlook is not programmed to handle newsgroups; I am not skilled enough to tell you how to resolve it but had the same problem. I now click the "view" tag in Outlook and then from there go to news which comes via Outlook Express. ...

Different Language Version Problem
I had downloaded the International Trial version of Money. Liked it. Uninstalled it. Bought the Complete Deluxe Version [U.S]. Tried to install it,.. But I get a message saying " A Different language version is already installed. Please remove the older version first & then try installing this version" .. ...I have already uninstalled the International Version. Tried Installing the Trial version again & re- uninstalling.. to no avail. Please Help. In microsoft.public.money, Kc wrote: >I had downloaded the International Trial version of Money. >Liked it. Uninsta...

TYPE CONVERSION
My goal is to automatically update the End Date to display the create date from a record previously reported. For example the end date for the first record listed below should be 9/24/2009 12:41:00 PM and the end date for the third record listed below should be 8/21/2009 9:00:00 AM. ID CATEGORY RANGE CREATE_DATE END_DATE 3426 Service 24 months 9/15/2009 9:35:00 AM 3426 Service 24 months 9/24/2009 12:41:00 PM 3426 Service 36 months 8/20/2009 12:23:00 PM 3426 Service 36 months 8/21/2009 9:00:00 AM I have the query listed belo...

Network problem.
I just recently did the upgrade to W7 from VISTA Home Premium 64Bit for the second time. The first time, I had issues with Start up and with a very slow boot which I was unable to resolve. The result was a need to restore the machine to the original factory setup using the HP restore disks. Quite the pain since everything needed to be updated, Windows as well as HP. This is an HP Pavilion KY811AA-ABA e9120y with 8 gigs ram and plenty of hd space. I redid the upgrade according to HP's Upgrade Adviser disks and things seemed to go much better than the first upgrade. BTW, the...

M2004 Deluxe-TIRA to Roth Conversion Question
Hi, I am using MS Money 2004 Deluxe. I did a Traditonal IRA conversion to a Roth back on Nov 24th. The conversion was with the same mutual fund, ticker symbol. How do I do the transaction within Money to effectively close the TIRA and have the Roth Start on 11/24/08? I want the converted amount, for tax purposes, to show up on the Money Home page. Thanks! Transfer Out investment activity? "Mike" <Mike@nothere.com> wrote in message news:%23UAtIoDaJHA.3908@TK2MSFTNGP06.phx.gbl... > I am using MS Money 2004 Deluxe. I did a Traditonal IRA conversion to a > Roth b...

Problem with Outlook 2003 calendar folder
I can't get my Calendar into my Folder List. It is accessible by clicking on the calendar button and opening the calendar in another window, but it will NOT show in the folder list. I have tried the following. 1) Applied every patch for outlook 2003 that microsoft provides. 2) outlook /resetfolders 3) When I try to add a new folder called "Calendar" I get a message that says it already exists. 4) uninstalled and reinstalled three times. (that includes wipping out all it's setting and pst tables) 5) I have clicked the "Folder list" button. I am not looking at an em...

Installation Problem #4
After installing Publisher 2003, every time I open it or even open a previously made document (from Publisher 200), a grey box comes up with installer instructions, loading installation information, and after about 2 minutes of this, the document finally opens. Since it is installed on the hard drive of the computer, how can this delay be eliminated. I work on a networked computer system, and no one else in the office has this problem! I have also tried a fix of: installing it, opening a document with the installation CD in the drive, and it still didn't work. Thank you for y...

Problems with array
Hello, I have been trying for awhile now in fixing this problem that I am having with this array and since I am getting no where I thought I might ask here for some help. Here is what I have: date time day evening night 24hrs. total cc\hour avg. cc\day avg. cc\week 5/14/04 0 5/14/04 0 5/14/04 0 5/14/04 0 0 0 0 * 5/15/04 200 5/15/04 375 5/15/04 0 5/15/04 ...

Conversations
I have searched for and got a list of 70 items in my inbox, which I now view as conversations, bbut the count at the bottom of the screen still shows '70 items'. Is there a quick and easy way to count the number of conversations, rather than the number of items? Thanks, G No. <george.walsh@doeni.gov.uk> wrote in message news:6798cc53-de91-4772-be4e-9de69dc45289@w40g2000hsb.googlegroups.com... >I have searched for and got a list of 70 items in my inbox, which I > now view as conversations, bbut the count at the bottom of the screen > still shows '70 items'. ...

American Express Sign and Travel payment problems
My American Express card has a 'Sign and Travel' account feature where it acts like two credit cards: one is the regular AMEX for all transactions except travel related expenses which go on to something more like a regular credit card. The number is the same, the statement is the same. The issue is that when I make payments, AMEX splits the payment up: if I owe $1000 for each of the two parts and make the full $2000 payment, AMEX shows two $1000 payments. The problem with Microsoft Money is that it keeps downloading the two payments and I can't reconcile them to the single trans...

Publisher 2000 conversion to PDF file
I made up a business card in Publisher 2000 using a photo and some text. It looks great but when I try to convert it to a PDF file either by using in house with Docudesk or sending it out to Zamzar it comes back in a set up of 10 cards on a 8x11 page like I am going to print in on some Avery format. It must be a setting in my Publisher program but I do not know how to correct it. Please help What size are the cards? Four to a page? Are you using Acrobat? Are you changing the page settings in the print options? If you are trying to print four to a page, Print, Select the PDF printer...

conversion
Hello, I'm dealing with a newsletter in Publisher format that I'd like in text form (I do not care about the Publisher special formatting or graphics). The newsletter will be converted to PDF and made available on a website. I would like a text alternative. Thank you. es What's wrong with MS Word or even Open Office or Word Pad if you don't have Word? Once your newsletter is created in Word or other text editor (strictly line text according to your post) print to a PDF creator, of which there are some free ones on the internet. "esha734" <esha734@discu...

Problem when exporting reports to Excel
When I export a report to an Excel (97) spreadsheet, category and subcategory totals appear not only in the Amount column but also in all other columns except the first column. This is annoying, and cleaning it up is time-consuming. This bug first appeared with Money Plus Premium. Is there a fix for it? -- -- Weird Harold In microsoft.public.money, Weird Harold wrote: >When I export a report to an Excel (97) spreadsheet, category and subcategory >totals appear not only in the Amount column but also in all other columns >except the first column. This is annoying, and cleaning...

excel sharing problems
I have a small business server and 5 members of staff (inc myself) who access and update 5 shared excel spreadsheets held on the server. Have been sharing spreadsheets for 3 years+ and started having problems (on & off) since new network and small biz server installed. Numerous problems but one which keeps popping up at different times is that one person can make changes, save on their computer, then everyone else saves but the 1st person's changes don't appear on everyone elses??? whats all this about?? Another problem we get is that the spreadsheet gets 'locked'...

Help with form/subform problem
I have a table, tblindividual, which holds names and addresses of officers. The primary key is ID. Each year they have to complete a registration form and return it to us in order that we can then send out a new registration card. So I have a table tblIDCards with Primary key CardID, and these fields ID, txtidform (date field) and txtidcardissued (also a date field) I have two problems to keep an annual record. 1. I have a form called frmMain (this is a menu form) with a subform, frmRegistration, which is based on a query which includes tblIndividual and on this form is a tabcontrol cal...

Vlookup, Index or Match
I posted this yesterday ... could not see ... so reposting it again Hello All, I am using Office 2003 and have the following problem: Sheet PROD (figures for example purpose only- it can be numeric or alpha numeric) Col B Col H 1 Mar-07 123 2 xx xx 3 xx xx 4 Mar-07 345 5 xx 6 Mar-07 678 7 Apr-07 910 8 xx xx 9 Apr-07 122 .... .... .... Below there are other months also...Col B will go down for a complete year. i.e. probably 500 Rows down. I have a Sheet name REPORTS where I wish to have the information from Sheet PROD when I input the Month ...

conversions
Hi: Does anyone know or if it possible to convert a Excel file to a PDF format? Thanks, Lisa Yes, you would need a conversion program like Adobe which will install a printer driver, then in excel you select file>print and change the default printer to adobe's driver. I have paperport 9.0 deluxe which also can install a pdf printer driver.. -- Regards, Peo Sjoblom "Lisa Murray" <lmurray@novamachine.com> wrote in message news:uKIeVLRrDHA.1724@TK2MSFTNGP10.phx.gbl... > Hi: > > Does anyone know or if it possible to convert a Excel file to a PDF format? &g...

Message Delivery Problem
A User has changed companies within a group. His old mailbox at user@oldco.com is still operating but copies of all inbound mail are now forwarded (by the server mail.oldco.com) to his new address at user@newco.com (mail.newco.com). Both servers are Exchange 2000 SP3 and are in seperate domains at different geographical locations. Mail sent internally from anyuser@oldco.com to user@oldco.com is being delivered/forwarded correctly to user@newco.com but external mail to user@oldco.com is not arriving at the new server and mailbox despite being sent by the oldco server. Messages that do a...