Skip site navigation (1) Skip section navigation (2)

Strange Problem. Please Help.

From: hengky liwandouw <hengky_liwandouw(at)yahoo(dot)com>
To: pgsql general <pgsql-general(at)postgresql(dot)org>, pgsql-odbc(at)postgresql(dot)org
Subject: Strange Problem. Please Help.
Date: 2007-02-26 13:06:42
Message-ID: 761093.54509.qm@web53302.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-odbc
Dear all,
   
  I have a very strange problem with Access 2003 as frontend and PqSql 8.1 as backend.
   
  In my access application, i have order form with orderdetail subform.
   
  Subform recordsource, based on a saved Access query that has very simple calculated field "AMOUNT" that calculate QTY*Unitprice. At the form footer, i have SUBTOTAL Textbox with "=sum(amount)" function. All fields has "standard" format, with 2 decimals
   
  The problem is : when subtotal should have decimals value eg. 123.45
   
  It just show 123.00
   
  What caused this problem ? I didn't experience the same problem with MDB tables database.
   
  I remember when i installed PostgreSQL, i check all function, and my database has about 500 fundred built in function !! Is this the source of problem ?
   
  Thank you for any help !

 
---------------------------------
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.

pgsql-odbc by date

Next:From: ioguixDate: 2007-02-26 13:10:13
Subject: Re: PLS Help. Linked tables in MS Access
Previous:From: hengky liwandouwDate: 2007-02-26 10:33:27
Subject: PLS Help. Linked tables in MS Access

pgsql-general by date

Next:From: Merlin MoncureDate: 2007-02-26 13:24:00
Subject: Re: [HACKERS] urgent: upgraded to 8.2, getting kernel panics
Previous:From: DANTE AlexandraDate: 2007-02-26 10:45:19
Subject: PostgreSQL 8.2.x and JDBC driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group