Re: Query value between min-max and return another value

Tech-Archive recommends: Fix windows errors by optimizing your registry

Jamie Collins wrote:

Marshall Barton wrote:

VBA does not support Decimal as a native variable type. It
is only available as a subtype of the Variant type.

Many thanks for your reply.

One thing: do you think it significant that VBA does not have a
*native* Decimal type? I tried to cover all the points in the following
thread:

Jet 4.0 DECIMAL type: VBA Decimal type and take up in Access
http://groups.google.com/group/microsoft.public.access/msg/076891d5343a0461?hl=en&;

Have I missed something?


Significant?? I think that's highly subjective, but because
of the other points I stated, I won't use it without a very
good reason.

I think you may be making valid points there, but the need
for the Decimal datatype (like the fixed length string) is
not great. This means that very few people are willing to
learn all of its nuances and thus it is avoided (as I do)
without a pressing need for the higher precision. Nothing
can eliminate rounding errors in any limitted precision
system that are introduced by multiplication, division,
etc, especially when the scale of the values varies, which
is where the issue is important.

I guess I'm saying that a good part of the answer to your
question is psychological. Way back when I wan in grad
school, we had a variable length number kind of computer.
Since this was the only kind of number, most people
specified the number width to be 100+ digits and then
complained about how slow the computer was. A brief
analysis of the calculations they were doing usually
determined that fewer than a dozen digits would be
sufficient and performance improved dramatically. Of course
computers are incredibly faster now and the variable length
number kind of machines are long gone, but user attitudes
are frequently formed by factors far from any specific
technical considerations.
--
Marsh
MVP [MS Access]
.

Quantcast