Recent content by sansiang

Already try it out. Work beautifully. By the way, it should be vRange(1) -vRange(0) , and not the other way round.

PeterL and Labbolt, both of you are wonderful. Your suggestion seem so simple and neat. I certainly have learn a new trick today.

Wow ! Looks inspiring... Will give it a try.

Hi, Have been looking for solution else where but not able to find it. In one table, I have a few fields. One of the field is "ItemSequence" and another one is "TotalPcs". "ItemSequence" is where user key in the sequence number for one or more item. 5 example for possible content of...

Hi everyone, This is Sansiang here. I do Access programming for my company own usage, since 3~4 years back. This forum have been very helpful all these time.