Has anyone experience a problem with some systems rounding numbers retrieved through queries, but other systems not?
For example, one of my users is on Windows NT, while I am using Windows XP. I am using Access 2002 to query records. A number returned from a query and placed on a report appears as 62 for me, but appears as 63 for her. I have not yet drilled down to the query level, as she is in a different state AND on a different server, and I have the only machine that can access both my Witness server and her server -- and it's an XP machine. However, I suspect that rounding is the problem.
For example, one of my users is on Windows NT, while I am using Windows XP. I am using Access 2002 to query records. A number returned from a query and placed on a report appears as 62 for me, but appears as 63 for her. I have not yet drilled down to the query level, as she is in a different state AND on a different server, and I have the only machine that can access both my Witness server and her server -- and it's an XP machine. However, I suspect that rounding is the problem.