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: ioguix||Date: 2007-02-26 13:10:13|
|Subject: Re: PLS Help. Linked tables in MS Access|
|Previous:||From: hengky liwandouw||Date: 2007-02-26 10:33:27|
|Subject: PLS Help. Linked tables in MS Access|
pgsql-general by date
|Next:||From: Merlin Moncure||Date: 2007-02-26 13:24:00|
|Subject: Re: [HACKERS] urgent: upgraded to 8.2, getting kernel panics|
|Previous:||From: DANTE Alexandra||Date: 2007-02-26 10:45:19|
|Subject: PostgreSQL 8.2.x and JDBC driver|