My problem is the amount is showing on the screen as 3.15654E+11 I need it to show the actual value which is 315,654,000,000
I already have the field set as double.
When I tried to import the field from a csv file, it created errors when I had the field set as Long Integer. When I changed it to double, I didn't get the errors but got the value of these larger amounts as 3.15654E+11
I tried to update query just those records to the value 315,654,000,000 but got another error.
Help!
9  1451 
My problem is the amount is showing on the screen as 3.15654E+11 I need it to show the actual value which is 315,654,000,000
I already have the field set as double.
When I tried to import the field from a csv file, it created errors when I had the field set as Long Integer. When I changed it to double, I didn't get the errors but got the value of these larger amounts as 3.15654E+11
I tried to update query just those records to the value 315,654,000,000 but got another error.
Help!
You are probably getting these results because the Format Property for this Numeric (Double) Field is set to Scientific. Explicitly set the Format of this Field to Standard, and its values should display normally. Let me know how you make out.
You may need to change the field to Long Integer
You may need to change the field to Long Integer
Mary:
315,654,000,000 is well beyond the limits of a Long Integer whose maximum value is somewhere in the area of 2,147,483,647.
NeoPa 32,556
Expert Mod 16PB
Good spot ADezii.
I suspect (I've had similar issues in the past) that the display will revert to scientific anyway for a number that large. In that case Text may be called for.
Rather than guess I tested it and it does work just as specified with a Double so no problem :)
Mary:
315,654,000,000 is well beyond the limits of a Long Integer whose maximum value is somewhere in the area of 2,147,483,647.
You are of course right. Sorry I was tired last night when doing this. Good catch.
thanks for all of your help. However, I still can't figure it out. How do you change the format of a field in a union query? I don't see where I can control that as I run the query. Any ideas?
thanks for all of your help. However, I still can't figure it out. How do you change the format of a field in a union query? I don't see where I can control that as I run the query. Any ideas?
This is the first time you've mentioned a UNION query. Can you post the query sql and we will see if we can help.
NeoPa 32,556
Expert Mod 16PB
It's not possible to control the output format of fields in a UNION query.
However, it can be done by using subqueries, or even (more easily), by using your UNION query as the source of a normal QueryDef (saved query).
Let me know if you want more info about subqueries in SQL.
NeoPa 32,556
Expert Mod 16PB
SQL Subqueries
While I was thinking about it I thought I'd post a tutorial on subqueries ( Subqueries in SQL).
Sign in to post your reply or Sign up for a free account.
Similar topics
by: CharitiesOnline |
last post by:
Hello,
I have set this script up to add paging to a search results page. Which on
the first page works fine. I calculates how many pages there should be
depending on the number of results returned...
|
by: laurenq uantrell |
last post by:
What I'm trying to do is to re-use the values of err.number and
err.description after displaying them in a MsgBox. The values seem to
auto clear and not be re-usable on a second reference.
For...
|
by: Ramesh |
last post by:
hi,
My C# application displaying correctly in IE, But in
netscape all input controls (text box, dblist, drop down
list and etc.,) disappered. Only lables are displaying.
The value inside the drop...
|
by: Siv |
last post by:
Hi,
I seem to be having a problem with a DataAdapter against an Access database.
My app deletes 3 records runs a da.update(dt) where dt is a data.Datatable.
I then proceed to update a list to...
|
by: Dany |
last post by:
Our web service was working fine until we installed .net Framework 1.1 service pack 1. Uninstalling SP1 is not an option because our largest customer says service packs marked as "critical" by...
|
by: JJ |
last post by:
I'm trying to create the cut/paste/select all context menu on number of
richtextboxes.
On the contextmenu.popup handler, I want to find out what control is
currently displaying the context menu....
|
by: Patxi |
last post by:
This is the first time I try to use cookies, and despite of reading some
tutotials, I'm have real trouble to make it work correctly. My cookie
reading code is in Master Page. When I click on a...
|
by: Phil |
last post by:
I thought it would be nice to display some animated GIFs on some of my
forms. I put a PictureBox control on a form, and loaded my GIF file in. It
animates, but not properly. It seems very jerky and...
|
by: cheltboy |
last post by:
At one of my client sites we noticed a few weeks ago that Listboxes
which previously showed "Yes" or "No" are now showing "-1" or "0". The
underlying tables and queries are displaying True/False...
|
by: =?Utf-8?B?aGVsZmk=?= |
last post by:
Hi all,
I have replied with my own questions to an older post entry
but after a while I thought it's better to start a new thread based on
the previous one. Perhaps with the new thread I will...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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,...
| |
