Decimal field size problems?

[Guest]

I have read posts about problems sorting with the Decimal field size. Does
anyone know of any other issues with that format?

 

[Allen Browne]

Sure. Here's a start:

Unrelated Rows in a Subreport or a Subform Are Returned When the Linkmaster
Property or the Linkchild Property Uses Decimal Fields:
http://support.microsoft.com/default.aspx?scid=kb;en-us;319547

BUG: ODBC call fails when filtering a decimal field in Access 2002:
http://support.microsoft.com/default.aspx?scid=kb;en-us;275108

ACC2002: #Name Appears in Linked Table When Decimal Field Has Identity Set
to Yes:
http://support.microsoft.com/default.aspx?scid=kb;en-us;282328

ACC2000: "Error 3701: 'Invalid Scale for Decimal Datatype'" Error Message
When You Try to Link an Informix Table to an Access Database:
http://support.microsoft.com/default.aspx?scid=kb;en-us;319485

ACC2000: Error Message When You Change the Properties on a Replicated Table
That Has a Decimal Column
http://support.microsoft.com/default.aspx?scid=kb;en-us;248909

If you are using Access 97, there are also problems where the Decimal data
does not display at all in a form.

 

[Guest]

Wow, thanks!

Sure. Here's a start:

Unrelated Rows in a Subreport or a Subform Are Returned When the Linkmaster
Property or the Linkchild Property Uses Decimal Fields:
http://support.microsoft.com/default.aspx?scid=kb;en-us;319547

BUG: ODBC call fails when filtering a decimal field in Access 2002:
http://support.microsoft.com/default.aspx?scid=kb;en-us;275108

ACC2002: #Name Appears in Linked Table When Decimal Field Has Identity Set
to Yes:
http://support.microsoft.com/default.aspx?scid=kb;en-us;282328

ACC2000: "Error 3701: 'Invalid Scale for Decimal Datatype'" Error Message
When You Try to Link an Informix Table to an Access Database:
http://support.microsoft.com/default.aspx?scid=kb;en-us;319485

ACC2000: Error Message When You Change the Properties on a Replicated Table
That Has a Decimal Column
http://support.microsoft.com/default.aspx?scid=kb;en-us;248909

If you are using Access 97, there are also problems where the Decimal data
does not display at all in a form.