Recent content by Anand Budhai

Thank you all for your input. I changed the Field size to double with format #.# and it worked. Regards AB

Hi Thanks for your reply. My issue is that when the weight is keyed in, it defaults to 1 digit only. eg 1.7 reflects as 1 only. I need the weight to reflect in 1 decimal point. Thanks Anand

Hi Yes, the R is the regional settings.

It is defined as a number and the format set as #.# The operator has to key in the scale reading (weight), which is calculated as follows eg. Scale reading 0.7kgs x (R5.00) Amt_Per Kg = Total R3.50 Anand

Hi I am struggling to format a number field on a table/query to reflect 1 decimal after a number. eg. 1.3 x R4.00 = R5.60 Field defaults to 1 number without the decimal, which calculates as 1 x R4.00 = R4.00 It would be appreciate if someone can assist me. Thanks Anand

Hi I am a new member that joined a minute ago. My name is Anand and I am from South Africa, Johannesburg. I work for Toyota South Africa Motors with 37 years of service. I have been using Microsoft Access for many years in my warehouse operations. Best Regards Anand