Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Posts
    45

    Unanswered: Values rounding when loaded into array...

    I am loading a table into a variant array using GetRows.

    The table has a field called "balance", and the first record is rounded (ie 46445). All of the other records have at least 5 decimal places for balance.

    The problem is that when the field is loaded into the array, all of the values are being rounded to 1 decimal place, and I need the additional granularity.

    Does anyone know of a way to load numeric values to an array with getrows and tell Access not to assume a rounding position?

    Thanks!

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    Numbers rounded

    Did you define your array as integer or real or decimal? I'm not sure but maybe you need to redefine your array. Scratch that...sorry didn't see you said "variant array"
    Last edited by pkstormy; 08-16-06 at 11:10.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Is this ADO or DAO?

    Can you change the order of the rows and, if so, does it make a difference (i.e. if the first value is not rounded)?
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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