Hi,
I can't seem to find how to format a custom search decimal column using the Jiwa 'Decimal places'. I have read it as the last field in the custom search :
"IN_Main.DecimalPlaces " & _
"FROM IN_Main LEFT JOIN
So I am using vbInteger temporarily as I don't want any decimals in this case.
Code I am using in the plugin is
.AddColumn("PartNo", vbString, "", 15, 2)
.AddColumn("Description", vbString, "", 30, 3)
.AddColumn("Avail.SOH.", vbInteger, "###.;\ ;\ ", 8, 4)
.AddColumn("Tot.SOH.", vbInteger, "###.;\ ;\ ",9, 5)
.AddColumn("Price", vbDecimal, "", 7, 6)
Basic query I know but I have tried most combinations with no success. Thanks
Doug