Access Table

's Computer Specifications

Can someone please confirm the Field property in a table for fixing the
STORED value of a curreny value to 2 decimal places.

Many thanks

Simon

's Computer Specifications

There is no property that controls the number of decimal digits STORED for
the Currency data type. The DecimalPlaces property defines what is
DISPLAYED. Try using the Decimal data type. I think it may allow you to
define the digits stored.

"Simon One" <(E-Mail Removed)> wrote in message
news:3139C7FF-94B6-4660-AFB2-(E-Mail Removed)...
> Can someone please confirm the Field property in a table for fixing the
> STORED value of a curreny value to 2 decimal places.
>
> Many thanks
>
> Simon

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
extracting data from linked db2 table using access make table quer	=?Utf-8?B?R2lueWN1YjIy?=	Microsoft Access External Data	0	29th Aug 2006 07:31 PM
Table properties from SQL table not propagated to Access table	=?Utf-8?B?UGV0ZXI=?=	Microsoft Access Database Table Design	0	8th Feb 2006 06:37 PM
Importing Excel into Access table creates blank rows to table?	=?Utf-8?B?ZWZhYWgw?=	Microsoft Access External Data	1	11th Jan 2006 03:57 PM
Exporting Access table/view to XML and importing XML file into a Access table	Karen Middleton	Microsoft Access External Data	0	4th Oct 2004 12:36 PM
How do I stop Access from asking confirmation to delete a table in a Make-Table Query?	Mike Webb	Microsoft Access Queries	4	8th Mar 2004 08:54 PM