Re: Strange display fo calculation resulot in Base query

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]
>
>
>
>
>  
>