Recent content by Tantan

Dear Alan, Well done!....Thank you so much. It works!

Dear AlanJ10, Thank you so much for your help. The added code at the end is the original one which only works for values less\more than 1. But I need the general rule which you have made and only the integer values should be placed in the table. Therefore, no fraction should be appeared...

Dear Modest, Imagine the following table with the it's data. Quantity 1.56 2.09 0.99 0.33 4.87 I want the code to do the following precedures: - Start with the 1stField (1.56). Count the int of 1.56 and replace the result with the field and keep the remain fraction into account and...