Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    1

    Unanswered: Stop rounding up in a linked table

    Can anyone tell me how to prevent rounding up in a table. I have tried to change the table properties from Long Integer to Decimal however I cannot as "This property cannot be modified in linked tables". Any help would be greatly appreciated. Thankx

  2. #2
    Join Date
    Apr 2009
    Posts
    10
    Did you ever get an answer to this? I am having the same issue. A SQL table linked into Access. In SQL it is numeric with 2 scale and in Access it rounds up no matter the format I put on it. IT is defaulting to a long integer data type.

Posting Permissions

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