Received: from s20.highertech.net (root@s20.highertech.net [209.54.120.20])
	by hub.org (8.9.3/8.9.3) with ESMTP id PAA05623
	for <pgsql-interfaces@hub.org>; Thu, 1 Jul 1999 15:16:43 -0400 (EDT)
	(envelope-from jt-kirkpatrick@mpsllc.com)
Received: from kirkpatrickjt (whiteoak-34.highertech.net [209.140.56.34] (may
	be forged))
	by s20.highertech.net (8.8.6/8.8.6) with SMTP id PAA05965;
	Thu, 1 Jul 1999 15:15:01 -0400
Received: by localhost with Microsoft MAPI; Thu, 1 Jul 1999 15:16:21 -0400
Message-ID: <01BEC3D4.AD2F64C0.jt-kirkpatrick@mpsllc.com>
From: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
To: "'asif@petstore.com'" <asif@petstore.com>
Cc: "'pgsql-interfaces@hub.org'" <pgsql-interfaces@hub.org>
Subject: 
Date: Thu, 1 Jul 1999 15:16:18 -0400
Organization: MPS, LLC
X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211
Encoding: 9 TEXT

>Subject: bug: Access sees money types incorrectly

it's the odbc -- it doesn't recognize the money type.  i have had to use 
int4, storing all entries *100 (i.e. 35.99 as 3599), and then on reports be 
sure to divide by 100.  DON'T use float4!!  in postgres6.5 i understand the 
newer numeric type is available, but i don't know if the odbc can use it 
yet. . .

jt