Can't use decimal type field as a linking field between main and subform?

[ddub]

Hi,

In my Access 2000 ADP I have a subform on my main form
based on two related tables. I use three fields to link
the forms together. One of the fields, SeqNo, is a
decimal type with a precision of 9 and scale of 2.

I put in a couple of test records from the SQL Server 2000
backend, some with no decimal points (i.e. 2,4,5) and some
with decimal points (i.e. .25,1.5,etc.). When I opened the
form, only records with the non-decimal numbers show up in
the subform.

Is it not possible to use a decimal type field as a
linking field between a main form and subform? Any help
would be greatly appreciated.

 

[Steve Jorgensen]

I'm guessing what's happening is that Access is converting the Decimal to a
Double, encurring binary rounding error, then using that value in the where
clause to try to find the child records.