Results 1 to 6 of 6

Thread: [RESOLVED] MS Access 97 Database Decimal Problem

Threaded View

  1. Feb 3rd, 2007, 06:56 AM #1
    khandu
    khandu is offline

    Thread Starter
    Addicted Member
    Join Date
    Dec 2006
    Posts
    139

    Resolved [RESOLVED] MS Access 97 Database Decimal Problem

    Hi

    Ive created a DB for VB6

    Now a field cost has the following

    field size : long integer
    format : general integer
    decimal places : 2

    Now whatever value is being put there.. its getting rounded off..

    I want it to be stored as 2 decimal places..

    So eg : I want the field to store number as 33.67 OR 99.01 .. or 99.00

    But it is rounding it off..

    can anyone tell me why is it rounding off and how to fix the field on any input to 2 decimal places..
    Last edited by khandu; Feb 3rd, 2007 at 07:46 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width