Results 1 to 4 of 4
  1. #1
    BRZ-Ryan is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2013
    Posts
    187

    Math operations with large numbers


    I am working with calculations that go larger than what a Double data-type can hold (result of Factorial(171+). To get around the limitation, I am using a function that calculates the factorial and holds the resulting value in a string. I need to perform division on this value, but I have no true data-type to hold it in to perform the calculation. I'm wondering if anyone has any math functions that accept the input values as strings. I'm sure someone has run into this issue in the past. I searched but came up with nothing.

  2. #2
    Xipooo's Avatar
    Xipooo is offline Sr. Database Developer
    Windows 8 Access 2013
    Join Date
    Jan 2014
    Location
    Arizona
    Posts
    332
    Have you tried putting your results into a variant data type instead of a string?

  3. #3
    BRZ-Ryan is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2013
    Posts
    187

    Re: Math operations with large numbers

    I believe a double is the largest data type so there's nothing vb can do.

  4. #4
    Xipooo's Avatar
    Xipooo is offline Sr. Database Developer
    Windows 8 Access 2013
    Join Date
    Jan 2014
    Location
    Arizona
    Posts
    332
    Quote Originally Posted by BRZ-Ryan View Post
    I believe a double is the largest data type so there's nothing vb can do.
    Variant is the same size as a double from what I understand, but if you try to go above a double in size it works as a string instead. Because this is determined during run-time this may afford you the flexibility you're looking for. Dunno if it will work, but I'd think it's worth a shot.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. switchboard operations
    By Deb4566 in forum Access
    Replies: 1
    Last Post: 03-15-2013, 04:16 PM
  2. What is routine database operations?
    By gaosanyong in forum Access
    Replies: 1
    Last Post: 12-13-2012, 02:40 PM
  3. Operations Between Records on a Table
    By swicklund in forum Queries
    Replies: 3
    Last Post: 03-27-2012, 01:42 PM
  4. Replies: 3
    Last Post: 05-15-2011, 11:03 PM
  5. Query to perform several special operations
    By Allison in forum Queries
    Replies: 4
    Last Post: 05-13-2011, 04:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums