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]
