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.