Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2016
    Posts
    29
    Provided Answers: 1

    Unanswered: More than 15 decimal places

    Hi guys,

    I'm rebuilding an Excel model in Access and I'm having a precision issue - the precision in Excel can in some places go to 20dp, and I apparently can't get more than 15dp in Access, which is having knock-on effects on my final results. Is there any way to hold (I'm less concerned about displaying) more than 15dp on data for calculation purposes?

    Thanks in advance

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    629
    Provided Answers: 32
    String value.

  3. #3
    Join Date
    Nov 2016
    Posts
    29
    Provided Answers: 1
    I used decimal and defined the precision and scale as 28 and 20 respectively in the end. Ironically, now I have the issue the other way around - Excel can only hold 15 s.f. so when I have a value in the thousands, I lose 4 d.p of precision in Excel, but not Access :/

Tags for this 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
  •