Gert,
I am using 125 and can or can recreate the problem, depends.
If I do nothting the my test returns values such as -1, -1.5.
I thought also that you wanted a SQL command to change the format, but
you can do this in Base objects.
If you have a Base query object then yes you can change the format. Just
open the query in Base, Highlite the column and select Column Format.
Set it to whatever you want. I set up as Scientific for exampel. Once
you do this any form that uses the Query will display the values usings
this new format setting.
You can not do the same with a table object.
HTH
Andrew Jensen
Gert Blij wrote:
OOo Beta 2 122 on Windows XP
I query 2 fields and use them to calculate a third, i.e.
SELECT `field1`, `field2`, `field1` - `field2` AS `Difference` FROM `table`
If field 1 > field2 the result displays correctly, but if field1 < field2 id
siplays in "scientific format" like 12E345.
Is there anyway to format the query so that the result displays as "-n"?
TIA
Gert
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
