Data type: Number, Field Size: Decimal, How do you declare it in VBDim statement?

[Stapes]

Hi

I have a field Quantity, defined in the Table Design as:
Dat Type: Number
Field Size: Decimal
Precision: 18
Scale: 3
Decimal Places: 3

How do I declare it in a VB Dim statement? (Visual Basic 6.3 - Access
2003).
It won't accept Dim quantity as decimal

Stapes

 

[Allen Browne]

Use a Variant.
You can coerce it to subtype decimal.

Example:
Dim varQty As Variant
varQty = CDec(5)